how to find the second highest salary from emp table?
Answer Posted / vinay
select max(sal) from emp where rownum = 2;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between alter trigger and drop trigger statements?
How can we solve sql error: ora-00904: invalid identifier?
What are the different types of tables in sql?
How can I get the number of records affected by a stored procedure?
What are system versioned tables?
what is top in tsql? : Transact sql
Is microsoft sql free?
What is sql in oracle?
What is a primary key? Explain
how to extract a unit value from a date and time? : Sql dba
what is timestamp in mysql? : Sql dba
Can a primary key be a foreign key?
How do I add a database to sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Do we need to rebuild index after truncate?