Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the logical query processing order of the various query clauses?

SQL Server 2000 2008
user-image
Question added by Hasan Habib , Digital Transformation Specialist , Tritech
Date Posted: 2013/10/26
Upvote (0) Views (4) Followers (0) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Shamas Imran
by Shamas Imran , Principal Software Engineer , Soliton Technologies

1. FROM2. ON3. OUTER4. WHERE5. GROUP BY6. CUBE | ROLLUP7. HAVING8. SELECT9. DISTINCT10 ORDER BY11. TOP

Adnan Hamdani

from[Event_part]as EP innerjoin[Event_signup]as ES on EP.SignUpId = ES.SignUpId,(selecttop1convert(varchar(10),eventDate,103)from[EventDate]where EventId=13Orderby eventDate) dates

Write Your Answer
More Questions Like This