Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151203 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 to convert characters to times in oracle?
Is oracle an operator?
How to connect the oracle server as sysdba?
How to create a stored program unit?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to get a list of all background sessions in the database?
How to rename a column in an existing table?
How to commit the current transaction in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
ABOUT IDENTITY?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to create a temporary table in oracle?
Why is oracle so popular?
how may join possible between (requisition with purchase order)
