how to get second highest salary in SQL(as/4000
Answer Posted / sachin
select max(salary) from emp_salary where salary<(select
max(salary) from emp_salary);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to display the records between two range in Oracle SQL Plus?
How does cross join work?
What are the possible values that can be stored in a boolean data field?
Where can I learn sql for free?
State some properties of relational databases?
What is procedure and function in sql?
How to download oracle sql developer?
What is sqlca in powerbuilder?
What is group by in sql?
What type of join is sql join?
What if we write return in procedure?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is a sql trace file?
Which software is used for pl sql programming?
What is date functions?