Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28049 Views
- I also Faced
- E-Mail Answers
Answer Posted / monika
select max(sal) from emp where sal<select max(sal) from emp
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
What is the use of double ampersand (&&) in sql queries? Give an example
What is a dirty read sql?
What are sql functions? Describe in brief different types of sql functions?
What is sqlite format?
define data blocks ? : Sql dba
Why do we use joins?
What is a sql profiler?
How do you update a table in sql?
What is the purpose of the partition table?
Will truncate release space?
Is it possible to create the following trigger: before or after update trigger for each row?
What is the difference between nvl function, ifnull function, and isnull function?
Explain clause in sql?
What is a dynamic query?
Can we join same table in sql?
