Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28795 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
Can we delete column in sql?
what are the advantages of sql ? : Sql dba
Write the command to remove all players named sachin from the players table.
How many clustered indexes can you have?
How does one use sql*loader to load images, sound clips and documents? : aql loader
Why do we need view in sql?
What is a left inner join?
How to run sql commands in sql*plus?
Is primary key is clustered index?
Why is sql important?
what is a trigger in mysql? : Sql dba
Is it mandatory for the primary key to be given a value when a new record is inserted?
Can we call dml statement in function?
What are its different types of dbms?
What is a sql statement?
