find out the third highest salary?
Answer Posted / hhh
select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
candidate key is subset of super key but not vice-verse explain
What is rich query?
master table and child table performances and comparisons in Oracle ?
Explain constraining triggers.
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is not equal to in oracle?
How to define a procedure inside another procedure?
What is MTTR advisor in Oracle?
how to make an oracle object
What is the difference between formal parameters and actual parameters?
How to get execution path reports on query statements?
What is the difference between online and offline backups?
How to download oracle database 10g xe?
How to create a server parameter file?
Explain about the analyze command in oracle?