Contoh dengan ORDER BY Contoh subquery Subquery berkorelasi Fungsi SQL Fungsi agregat ANY_VALUE APPROXIMATE PERCENTILE_DISC AVG BOOL_AND BOOL_ATAU COUNT and COUNT DISTINCT fungsi COUNT LISTAGG MAX MEDIAN MIN PERCENTILE_CONT STDDEV_ SAMP dan STDDEV _ POP SUM and SUM DISTINCT VAR_ SAMP dan VAR _...
AzureDiagnostics | where ResourceProvider =="MICROSOFT.DBFORMARIADB" | where Category == 'MySqlAuditLogs' and event_class_s == "connection_log" | project TimeGenerated, LogicalServerName_s, event_class_s, event_subclass_s, event_time_t, user_s , ip_s , sql_text_s | order by TimeGe...
select firstname, lastname, city, max(qtysold) as maxsold from users join sales on users.userid=sales.sellerid where users.city not in(select venuecity from venue) group by firstname, lastname, city order by maxsold desc, city desc limit 10; firstname | lastname | city | maxsold ...
val df_temps = spark.sql("SELECT * FROM zzz_demo_temps_table " + "WHERE AirportCode != 'BLI' AND Date > '2021-04-01' " + "GROUP BY AirportCode, Date, TempHighF, TempLowF " + "ORDER BY TempHighF DESC") df_temps.show() // Results: // +---+---+---+---+ // | ...
SQLAssessmentRecommendation SecurityAttackPathData SecurityEvent SentinelAudit SignalRServiceDiagnosticLogs SigninLogs StorageBlobLogs StorageCacheOperationEvents StorageCacheUpgradeEvents StorageCacheWarningEvents StorageMalwareScanningResults SucceededIngestion SynapseLinkEvent Syslog TSIIngress UCDOAggregatedStatus UCDOSta...
union serviceSideParticipants, clientSideParticipants | summarize hint.strategy = shuffle arg_max(Rank, *), EntityPayload_Merged = make_bag(EntityPayload), Insights_Payload_Merged = make_bag(Insights_Payload), Insights_HasIssues_Merged = countif(Insights_HasIssues) > 0 by EntityId | order by ...