how to find nth highest salary
Answers were Sorted based on User's Feedback
Answer / haribabuboddapati
select max(sal)*from emp
where sal>select max(sal)*from emp
| Is This Answer Correct ? | 24 Yes | 100 No |
Answer / rajendra prasad reddy penumall
select salary=max(salart)from from EmpMaster
| Is This Answer Correct ? | 17 Yes | 182 No |
Answer / rajendra prasad reddy penumall
select salary=max(salart)from from EmpMaster
| Is This Answer Correct ? | 20 Yes | 206 No |
How to throw custom exception in Stored Procedure?
What is difference in performance between insert top (n) into table and using top with insert?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
When is update_statistics command used?
How to encrypt Strored Procedure in SQL SERVER?
What are the five characteristics of good data?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is updatable resultset?
What are various ways to enhance the ssrs report?
What information is maintained within the msdb database?
What is self contained sub query?
Why I am getting this error when renaming a database in ms sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)