how to find the second highest salary from emp table?
Answer Posted / monika
Select salary from emp order by salary desc LIMIT 1,1;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the difference between inner join and outer join?
What are the two types of periodical indexes?
What are the different types of constraints?
How show all rows in sql?
What is difference between ms sql and mysql?
What is execution plan in sql?
What are the advantages of sql? Explain
How to select random rows from a table?
What is difference between sql and excel?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Why select is used in sql?
What kind of join is join?
How do I save a stored procedure?
What is rank dense_rank and partition in sql?
How do I add a database to sql?