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
how to return query output in html format? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
how would you get the current date in mysql? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
What is where clause in sql?
How do I partition in sql?
What is the difference between rollback and rollback to statements?
What is an emotional trigger?
What are triggers and its uses?
which operator is used in query for pattern matching? : Sql dba
What is an example of translating a date into julian format?
Enlist the characteristics of pl/sql?
Why truncate is faster than delete?
What are pl/sql cursor exceptions?
What view means?