Scribd
Upload
10 views1 page

Beginner SQL Query Basics Guide

Uploaded by

roobiniprincess
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views1 page

Beginner SQL Query Basics Guide

Uploaded by

roobiniprincess
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL Notes (Beginner Friendly)

1. SELECT:
SELECT * FROM table;
2. WHERE:
SELECT * FROM table WHERE condition;
3. ORDER BY:
SELECT * FROM table ORDER BY column;
4. GROUP BY:
SELECT column, COUNT(*) FROM table GROUP BY column;
5. JOIN:
SELECT * FROM A INNER JOIN B ON [Link] = [Link];
6. Functions:
COUNT(), SUM(), AVG(), MIN(), MAX()

You might also like