Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28035 Views
- I also Faced
- E-Mail Answers
Answer Posted / arif saulat
select * from emp where sal <(select max(sal) from emp)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is sql and db2?
What are the different parts of a package?
How do you get column names only for a table (sql server)?
What is the difference between unique and primary key constraints?
Is ms sql is free?
How to select unique records from a table?
Does sql*plus also have a pl/sql engine?
what is online transaction processing (oltp)? : Sql dba
What if we write return in procedure?
How do you use collections in procedure to return the resultset?
What is difference between stored procedure and trigger?
How does rowid help in running a query faster?
What is a pl/sql block?
how to do backup entire database? : Transact sql
What is full join?
