Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 19846 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / krishna kumar r
SELECT E1.ENAME,E1.SAL FROM EMP E1 WHERE 3>(SELECT COUNT(*)
FROM EMP E2 WHERE E2.SAL>E1.SAL ) ORDER BY SAL DESC
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to write an inner join with the where clause in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the system predefined user roles?
How to define a data source name (dsn) in odbc manager?
What privilege is needed for a user to query tables in another schema?
How many types of synonyms in Oracle?
What is an oracle wallet?
What is a proxy class?
What is the difference between $oracle_base and $oracle_home?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Can we convert a date to char in oracle and if so, what would be the syntax?
What is a nvl function?
What is define in oracle?
What is connection pooling in oracle?
