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
Explain the creation and execution of a user-defined function in the sql server?
What is the use of keyword with encryption. Create a store procedure with encryption?
Define primary key?
What is the most common type of join?
How to update muliple row in single query?
Can two tables have the same primary key?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is the difference between set and select?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How to disable triggers using "disable trigger"?
Explain tablesample?
What is report rendering ?
What happens on checkpoint?
how you can list all the tables in a database?
Explain transaction server auto commit?