Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64217 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
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the ansi data types supported in oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Can we protect our pl/sql source code?
Is java required for oracle client?
Why is oracle database so popular?
What is ADDM Advisor in Oracle?
What is the usage of analyze command in oracle?
How to export your connection information to a file?
When do you get a .pll extension in oracle?
How do you store pictures in a database?
What are the ways tablespaces can be managed and how do they differ?
Explain how you would restore a database using RMAN to Point in Time?
How to select an oracle system id (sid)?
