Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65472 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / asdasd
SELECT min(gross) FROM(SELECT distinct(gross) FROM
srbs_staff_pay_dtls ORDER
BY gross DESC) WHERE ROWNUM<=4;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is an oracle database?
What is oracle rowcount?
What is the difference between substr and instr?
What is query image?
What is proxy method?
What is the disadvantage of User defind function?
What is the Tune Query
How to convert dates to characters in oracle?
How to define a cusotmer as a supplier in ORACLE R12
How to use values from other tables in update statements using oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is the use of oracle?
How to create a table index in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is the string concatenation operator in oracle?
