a query to select maxmun 3 salaries of employee table
Answer Posted / suresh babu
select * from employees a where 3 <= select count(distinct
b.salary) from employees b where a.salary >= b.salary);
This query,which returns the first maximum salary from
employees table.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is parameterized cursor in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is a view and how is it different from a table?
what are bitmap indexes? How does they work?
When do we use group by clause in a sql query?
How to update values in a table in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What are the execution control statements?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain the use of Merge statement in oracle 11g
Explain the truncate in oracle?
What happens to the data files if a tablespace is dropped?
How can I combine multiple rows into a comma-delimited list in oracle?
Explain what are clusters?
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