how to find the second highest salary from emp table?
Answer Posted / jhansi
select max(sal) from emp where sal<any(select max(sal) from
emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how is myisam table stored? : Sql dba
Which join condition can be specified using on clause?
What is the use of sqldataadapter?
what is a constraint? Tell me about its various levels. : Sql dba
What are packages in pl sql and also explain its advantages?
How would you convert date into julian date format?
Which is better join or subquery?
What is the sql case statement?
How to run sql*plus commands in sql developer?
What is the process of debugging?
Can we use joins in subquery?
What is embedded sql what are its advantages?
What does select * from mean in sql?
Is sql sequential or random?
What is a pragma statement?