SQL Basic Query Notes

Operational sequencing
From
On
Join
where
GROUP BY
With cube or with rollup not
Having
Select
Distinct
ORDER BY
Top

Select *from ... Querying all data

A convenient process for filtering data

Start position from =c# foreach where filter condition =foreach{loop body If judgment} Select mapping Transcription * Copy line Select to last run from middle

Top

How many bars before filtering

Select top 2 *from ... where: Like '%.. %‘
Top Last Run
Like fuzzy query% _ [] [^]

_ occupies one character in a position that can be any character
[] In this character position can be any one of the brackets within the range
[^] not within the range

SLELCT distinct (de-weight) brand from.
Distinct after Select

Select *from. ORDER BY:
Order by sort default from low to high ASC (can not be written) Ascending desc Descending
Behind the select top in order BY

Where behind filter
Compare operators < > <= >=! =
Logical operator and OR

Select *from. Where: Like: and.. <, ....

SQL Basic Query Notes