Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
- 6 Answers
- 8394 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
select top(2) sal from emp where sal order by desc
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to fetch the row which has the max value for a column?
What do you mean by group by clause?
What are the limitations of check constraint?
How are extents allocated to a segment?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Why do you create or replace procedures rather that drop and recreate.
How to put more than 1000 values into an oracle in clause?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to define and use table alias names in oracle?
How to download oracle database 10g xe?
What types of joins are used in writing subqueries?
List the various oracle database objects?
How to create a testing table in oracle?
what is reindexing?
11. Display the client number and name and the client number and name of the person who referred that client.
