how to find nth highest salary
Answer Posted / haribabuboddapati
select max(sal)*from emp
where sal>select max(sal)*from emp
| Is This Answer Correct ? | 24 Yes | 100 No |
Post New Answer View All Answers
How to define output parameters in stored procedures?
How many non clustered indexes there can be on table ?
How to copy the tables, schema and views from one sql server to another?
What is resource governor in sql server?
Explain the advantages of merge replication?
How to delete database objects with "drop" statements in ms sql server?
What is difference between rownum and rowid?
What happens if null values are involved in comparison operations?
what is the difference between a primary key and a unique key? : Sql server database administration
How to check if a table is being used in sql server?
What do you mean by the term 'normalization'?
how can a database be repaired? : Sql server administration
What is the fastest way to permanently delete a 1 million row table named customers?
what is datawarehouse?
Explain the third normal form(3nf)?