Differences

This shows you the differences between two versions of the page.

--- postgres_sql_cheat_sheet [2025/01/13 22:43] – created stephen
+++ postgres_sql_cheat_sheet [2025/01/14 02:52] (current) – stephen
@@ Line 3: / Line 3: @@
 For MS SQL, see [[sql_cheat_sheet|SQL Cheat Sheet]]
-===== TOP =====
+===== Basic Query =====
+Put column names in double quotes.
+<code sql>
+SELECT
+      "ApiResources"."Name" AS ApiResourceName
+    , "ApiResources"."DisplayName" AS ApiResourceDisplayName
+    , "ApiScopes"."Name" AS ScopeName
+    , "ApiScopes"."DisplayName" AS ScopeDisplayName
+    , "ApiResources".*
+FROM
+    config."ApiResources"
+LEFT JOIN
+    config."ApiScopes"
+    ON "ApiResources"."Id" = "ApiScopes"."ApiResourceId"
+WHERE 1 = 1
+    AND "ApiScopes"."Name" = 'xero_identity_test'
+</code>
+===== TOP n =====
+Use ''LIMIT n'' instead.
 <code sql>