how to find the second highest salary from emp table?
Answer Posted / nirjesh pandey
select salary from employee order by salary DESC LIMIT(1,1);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is sql difficult?
What is the left table in sql?
What is the difference between instead of trigger and after trigger?
where are cookies actually stored on the hard disk? : Sql dba
What are the features of pl sql?
What is a composite primary key?
what are the advantages a stored procedure? : Sql dba
what are set operators in sql? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
How do you exit in sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is a system versioned table?
Is and as keyword in pl sql?
What is having clause in sql?
How do you select unique values in sql?