how to find the second highest salary from emp table?
Answer Posted / sathiavathi
select max(salary) from employee where salary!=(select max
(salary) from employee);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How long will it take to learn pl sql?
How do you concatenate in sql?
Are stored procedures compiled?
What is primary key and unique key?
What is the usage of distinct keyword?
What is sql exception?
Why are cursors used?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
explain advantages of innodb over myisam. : Sql dba
What is type and rowtype in pl sql?
What is the difference between syntax error and runtime error?
when is the use of update_statistics command? : Sql dba
what is data integrity? : Sql dba
What is java sql drivermanager?
What is $$ in sql?