how to get second highest salary in SQL(as/4000
Answer Posted / ramesh.p
Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;
| Is This Answer Correct ? | 10 Yes | 19 No |
Post New Answer View All Answers
how can we destroy the cookie? : Sql dba
what is acid property in database? : Sql dba
How do you create a db file?
What does select count (*) mean in sql?
What is the most restrictive isolation level? : Transact sql
How delete all records from table in sql?
What is a dynamic query?
Which tcp/ip port does sql server run?
What is primary key and foreign key?
Why are indexes and views important to an organization?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is tuple in sql?
How do I remove all records from a table?
How can you load multi line records? : aql loader