how to find the second highest salary from emp table?
Answer Posted / ashwini
select max(salary) from employee where salary < (select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can I change database name in sql?
what is the difference between truncate and delete statement? : Transact sql
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Which query operators in sql is used for pattern matching?
Can triggers stop a dml statement from executing on a table?
What is right join sql?
What is full join in sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are different types of keys?
What are the types of operators available in sql?
What is set serveroutput on in pl sql?
How do I make my sql query run faster?
What is the difference between null value, zero, and blank space?
What is an intersect?
What is an oracle stored procedure?