Find out the 3rd highest salary?
Answer Posted / divya c
Select max(sal) from emp
where sal<(select max(sal) from emp where sal<(select max
(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is schema in sql example?
Is sql easier than java?
what is the difference between group by and order by in sql? : Sql dba
What is on delete restrict?
What are the benefits of triggers?
What are the benefits of stored procedures?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is db journal file?
What is join view in sql?
What is sql injection vulnerability?
Which operator is used in query for pattern matching?
What is substitution variable?
How to use boolean type in select statement?
What is a design view?
Explain the steps needed to create the scheduled job?