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