how to find the second highest salary from emp table?
Answer Posted / gunjal ghagre
Select sal from table_name order by sal desc limit 1,1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are date and time functions in mysql? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How to take user input in pl sql?
Can I call a procedure inside a function?
What is an exception in pl/sql?
What is a system versioned table?
Is microsoft sql free?
What is pl/sql language case sensitive?
what is 'mysqlimport'? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?
Why use triggers in sql?
What is a schema? How is it useful in sql servers?
Is keyword pl sql?
What do you think about pl/sql?
What is sql used for?