how to get second highest salary in SQL(as/4000
Answer Posted / praveen agrawal
select sal from employee order by sal desc limit 1,1;
its 100% true i have checked it out.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do I find duplicates in the same column?
What is a full join sql?
what are the join types in tsql? : Transact sql
Is sql scripting language?
Why indexing is needed?
what is self-join? : Sql dba
What is set serveroutput on?
What types of commands can be executed in sql*plus?
how many ways to get the current time? : Sql dba
Can pl sql procedure have a return statement?
what are wild cards used in database for pattern matching ? : Sql dba
What is crud stand for?
What is t sql in sql server?
write an sql query to find names of employee start with 'a'? : Sql dba
what are numeric data types? : Sql dba