1. Functiile standart si nestandart al analizei
- TOP (T-SQL)
- OFFSET/FETCH (standart SQL)
- NTILE (T-SQL)
- PIVOT si UNPIVOT(T-SQL)
2.Functia TOP
- Extrage primele n coloane
- Se foloseste intotdeauna cu op. ORDER BY
EX.1
SELECT TOP (4) project_name, budget
FROM project
ORDER BY budget DESC;