Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150700 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / ruchira
select sal from emp
where sal =
(select sal from
(select distinct sal from emp OrderBy sal desc)
[table alias] where rownum < 4 )
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How many data types are supported?
What is Virtual Private Database in Oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What do you mean by a deadlock?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to Truncate Table in Oracle
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to convert dates to characters in oracle?
Explain oracle left join with an example?
How to test null values?
What is a procedure in oracle?
How do we display rows from the table without duplicates?
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.
How to retrieve the count of updated rows?
Explain what are the uses of rollback segment?
