Answer Posted / cpnagar
select top 1 salary from(select distinct top 3 salary from
emp order by salary desc)as e order by e.salary
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is the difference between deallocate cursor and close cursor?
What is the use of custom fields in report?
What is ddl and dml commands?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to provide values to stored procedure parameters in ms sql server?
What stored by the model?
Explain the difference between control flow and data flow?
What are the extra roles available in msdb? : sql server security
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How will you make an attribute not process? : sql server analysis services, ssas
What is spatial and temporal data?
What are the hotfixes and patches in sql server?
Explain few examples of RDBMS?
What is the use of builtinadministrators group in sql server? : sql server security
What is sql server agent and what are the two modes of authentication in sql server?