how to find the second highest salary from emp table?
Answer Posted / kameshwar shukla(a.i.e.t l.k.o
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 the difference between delete and truncate commands?
What is clustered index sql?
What is parameter substitution in sql?
what are string data types? : Sql dba
how to drop an existing index in mysql? : Sql dba
What is example of database?
what is the difference between sql and t-sql? : Transact sql
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are the different schemas objects that can be created using pl/sql?
what is the difference between nested subquery and correlated subquery?
What is data modelling in sql?
Explain alias in sql?
Mention what pl/sql package consists of?
What's the difference between a primary key and a clustered index?
Explain raise_application_error.