how to get second highest salary in SQL(as/4000
Answer Posted / deepak
select max(sal) from emp where sal!=(select max(sal) from emp);
Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
What is sql*plus?
What are the various levels of constraints?
What is null in pl/sql?
Which is faster count (*) or count 1?
what are date and time data types? : Sql dba
What are views in sql?
What is the best partition size for windows 10?
What are different sql data types?
What are the indexing methods?
What is procedure explain with example?
What is an alias command?
What is bulk compiling in pl/sql.?
What jobs use sql?
What is varray in pl sql?
How do I send sql query results to excel?