how to find the second highest salary from emp table?
Answer Posted / muhammed zaheer
select max(sal) from emp where sal < (select max(sal) from
emp)
| Is This Answer Correct ? | 86 Yes | 16 No |
Post New Answer View All Answers
What steps server process has to take to execute an update statement?
explain advantages of myisam over innodb? : Sql dba
What is int identity in sql?
What is the use of & in pl sql?
How to use transactions efficiently : transact sql
Which is better cte or subquery?
How long it takes to learn pl sql?
Can a foreign key be null?
how can we optimize or increase the speed of a mysql select query? : Sql dba
How can a function retun more than one value in oracle with proper example?
What is difference between nchar and nvarchar?
what is 'mysqldump'? : Sql dba
What is the importance of sqlcode and sqlerrm?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Give the order of sql select?