what is the order of execution of where,having,group by in
select stement
Answer Posted / lakshmi
from clause
where
group by
having
distinct
order by
select
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
How to use group functions in the select clause in ms sql server?
What is the fillfactor concept in indexes?
What is the use of toad or sqldbx.?
What is a Join and explain its types?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are the steps you should follow to start sql server in single-user mode?
How to enter binary string literals in ms sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is normalization of database?
What the different components of Replication and what is their use?
What is the difference between stored procedure and user defined functions?
What is the chart in report?
Can we perform backup restore operation on tempdb? : sql server database administration
What are different types of collation sensitivity?
What is single-user mode?