Order of SQL Query processing
1. FROM (Choose and join tables to get base data)
- table to query
- join
2. WHERE (Filters the base data)
- filter rows
- only rows for which predicates is true
3. GROUP BY (Aggregates the base data)
- it associates each input rows to its respective group
4. HAVING (Filters the base data)
- filters the aggregated data.
5. SELECT(Window functions happen here!)
- returns the final data
6. ORDER BY
-Sorts the final data
7. OFFSET FETCH (LIMIT,Paging)
- Limits the returned data toa row count
Subscribe to:
Post Comments (Atom)
SOLID-Design-Principles
SOLID-Design-Principles The SOLID principles are fundamental to designing effective, maintainable, object-oriented systems. Whether you...
Full Stack developer course in Hyderabad
ReplyDeleteThe article offers useful and easy-to-understand tips. It presents the information in a clear and engaging way. It’s a great resource for those who want to gain knowledge quickly.