Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37898 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / b.v.siva kumar
Use this for SQL Server:
select top 1 salary from emp where salary in (select
distinct top 3 salary from emp order by salary desc) order
by salary
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explian rowid, rownum? What are the psoducolumns we have?
tell us something about heap tables. : Sql dba
Explain ddl statements in pl/sql?
Can function return multiple values in sql?
How many indexes can be created on a table in sql?
What is field delimiter?
Name the operator which is used in the query for pattern matching?
What is constant in pl sql?
What is a system versioned table?
Explain the insert into statements in sql?
Is pl sql a scripting language?
How do you update a sql procedure?
Is it mandatory for the primary key to be given a value when a new record is inserted?
what is cross join? : Sql dba
How show all rows in sql?
