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
Explain what are the database objects? : SQL Server Architecture
How each E-R model constructs can be mapped to the relational model?
How do I save a stored procedure in sql server?
How do I make a resultset scrollable?
What is the simplest way to create a new database in ms sql server?
How to list all columns in a table using odbc_columns()?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What do you understand by recursive stored procedure?
What is the federation in sql azure?
Explain full-text indexing?
What are the different methods available under sqlcommand class to access the data?
Is it safe to delete log files?
What is meant by referential integrity?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Define self join in sql server joins?