from clause where group by having distinct order by select

what is the order of execution of where,having,group by in
select stement

Question Posted / lakshmi

Answer Posted / lakshmi

from clause
where
group by
having
distinct
order by
select

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain the rules for designing files and file groups in sql server?

984

Explain the different types of joins?

992

What are different type of Collation Sensitivity?

998

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

983

What are trace files?

950

What is the fillfactor concept in indexes?

980

How to select some specific columns from a table in a query in ms sql server?

1002

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1940

How do you identify a foreign key?

1021

Explain the functionalities that views support?

1112

What is multi-statement table-value user-defined function?

991

What is the difference between locking and multi-versioning?

985

Explain the truncate command? : SQL Server Architecture

1166

What are a scheduled jobs or what is a scheduled tasks?

899

What is temporal data type?

916