Snowflake SQL — Dark
Worksheets
Snowflake
CTE
MERGE
+
PREVIEW
ACCOUNTADMIN
DWH
Share
Syncing changes from PostgreSQL…
CUSTOMERS.PUBLIC
Updated 2 seconds ago
1
SELECT
*
from
customers.public.food
order by
id
asc
;
2
SELECT
*
from
customers.public.food
order by
id
desc
;
Results
Chart
ID
NAME
1
1
Macadamia
2
2
Sea Bass
3
3
Capers – Ox Eye Daisy
4
4
Nut – Pistachio, Shelled
5
5
Melon – Cantaloupe
6
7
Salt – Celery
7
8
Ostrich – Fan Fillet
Aa NAME
Macadamia