Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19142 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / avnish srivastava-test engg fc
select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))
| Is This Answer Correct ? | 10 Yes | 11 No |
Post New Answer View All Answers
How can you use check constraints for self referential integrity?
How to divide query output into groups in oracle?
What is PL/SQL ?
What are the execution control statements?
What is partitioned table in Oracle?
What is define in oracle?
How to convert raw data type into text in oracle? Explain
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How many file formats are supported to export data?
What is the difference between substr & instr functions?
What is an oracle database?
How to define and use table alias names in oracle?
How to use subqueries with the in operator using oracle?
How do you bind variables in oracle?
