TGViewer
SQL Programming Resources SQL Programming Resources @sqlanalyst ยท 76.7K subscribers
Post #2338 4.71K
โœ… ๐Ÿ”ค Aโ€“Z of SQL Commands ๐Ÿ—„๏ธ๐Ÿ’ปโšก

A โ€“ ALTER
Modify an existing table structure (add/modify/drop columns).

B โ€“ BEGIN
Start a transaction block.

C โ€“ CREATE
Create database objects like tables, views, indexes.

D โ€“ DELETE
Remove records from a table.

E โ€“ EXISTS
Check if a subquery returns any rows.

F โ€“ FETCH
Retrieve rows from a cursor.

G โ€“ GRANT
Give privileges to users.

H โ€“ HAVING
Filter aggregated results (used with GROUP BY).

I โ€“ INSERT
Add new records into a table.

J โ€“ JOIN
Combine rows from two or more tables.

K โ€“ KEY (PRIMARY KEY / FOREIGN KEY)
Define constraints for uniqueness and relationships.

L โ€“ LIMIT
Restrict number of rows returned (MySQL/PostgreSQL).

M โ€“ MERGE
Insert/update data conditionally (mainly in SQL Server/Oracle).

N โ€“ NULL
Represents missing or unknown data.

O โ€“ ORDER BY
Sort query results.

P โ€“ PROCEDURE
Stored program in the database.

Q โ€“ QUERY
Request for data (general SQL statement).

R โ€“ ROLLBACK
Undo changes in a transaction.

S โ€“ SELECT
Retrieve data from tables.

T โ€“ TRUNCATE
Remove all records from a table quickly.

U โ€“ UPDATE
Modify existing records.

V โ€“ VIEW
Virtual table based on a query.

W โ€“ WHERE
Filter records based on conditions.

X โ€“ XML PATH
Generate XML output (mainly SQL Server).

Y โ€“ YEAR()
Extract year from a date.

Z โ€“ ZONE (AT TIME ZONE)
Convert datetime to specific time zone.

โค๏ธ Double Tap for More
  • โค 20
More from @sqlanalyst
  1. Oct 12, 2026SQL Interview Series โ€” Part 6 ๐Ÿ“Œ Question 6: Find the Top 2 Highest-Paid Employees in Eachโ€ฆ
  2. Oct 12, 2026๐Ÿš€ ๐—ช๐—ต๐—ถ๐—ฐ๐—ต ๐—ง๐—ฒ๐—ฐ๐—ต ๐—ฆ๐—ธ๐—ถ๐—น๐—น ๐—ช๐—ถ๐—น๐—น ๐—ฌ๐—ผ๐˜‚ ๐— ๐—ฎ๐˜€๐˜๐—ฒ๐—ฟ ๐—ถ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ? Want to builโ€ฆ
  3. Oct 9, 2026SQL Interview Series โ€” Part 5 ๐Ÿ“Œ Question 5: Find Employees Who Earn More Than Their Managโ€ฆ
  4. Oct 9, 2026๐Ÿ‡ฎ๐Ÿ‡ณ ๐—š๐—ข๐—ฉ๐—˜๐—ฅ๐—ก๐— ๐—˜๐—ก๐—ง ๐—ข๐—™ ๐—œ๐—ก๐——๐—œ๐—” โ€” ๐—”๐—œ๐—–๐—ง๐—˜ ๐—œ๐—ก๐—ง๐—˜๐—ฅ๐—ก๐—ฆ๐—›๐—œ๐—ฃ๐—ฆ ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ ๐Ÿš€โ€ฆ
  5. Oct 8, 2026๐ŸŽ“ ๐— ๐—ถ๐—ฐ๐—ฟ๐—ผ๐˜€๐—ผ๐—ณ๐˜ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ฒ๐˜€! ๐Ÿš€๐Ÿ”ฅ Upgrโ€ฆ
  6. Oct 7, 2026๐Ÿš€๐—ฃ๐—ฎ๐˜† ๐—”๐—ณ๐˜๐—ฒ๐—ฟ ๐—ฃ๐—น๐—ฎ๐—ฐ๐—ฒ๐—บ๐—ฒ๐—ป๐˜ ๐—ง๐—ฟ๐—ฎ๐—ถ๐—ป๐—ถ๐—ป๐—ด | ๐—•๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ ๐—™๐˜‚๐—น๐—น๐˜€๐˜๐—ฎ๐—ฐโ€ฆ
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook โ†’Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 โ†’