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
What is 3nf normalization?
What is scheduled job and how to create it?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
How do I find the size of a sql server database?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is bit data type?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is the log shipping?
what is database replicaion? : Sql server database administration
What are the different types of stored procedures?
What is inner join in sql server joins?
Can you type more than one query in the query editor screen at the same time?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Can you explain important index characteristics?