Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20368 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / raju
select * from emp a where 3>=(select count(distinct(b.sal))
from emp b where b.sal>=a.sal )
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is difference between truncate and delete?
How can Oracle users be audited?
What is sharded cluster?
What is rich query?
How can I get column names from a table in oracle?
How to create a table in a specific tablespace?
Explain the use of record length option in exp command.
How to create a new table in your schema?
What is the usage of save points in oracle database?
Please explain oracle data types with examples?
What is the difference between 10g OEM and 11g OEM?
What are the predefined tablespaces in a database?
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
How can we force the database to use the user specified rollback segment?
What is the difference between substr & instr functions?
