how to find the second highest salary from emp table?
Answer Posted / nitin
select max(salary) from emp where salary<>(select
max(salary) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between local variables and global variables?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is the file extension for sql database?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
how many groups of data types? : Sql dba
Is sql injection illegal?
How global cursor can be declare with dynamic trigger ?
what is heap table? : Sql dba
Does asenumerable execute the query?
How do I kill a query in postgresql?
What is package in pl sql?
explain advantages of innodb over myisam. : Sql dba
what is top in tsql? : Transact sql
Is sql between inclusive?
Can we use join in subquery?