Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 18734 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / jainish
select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
How to generate query output in html format?
What is memory advisor in Oracle?
How is it different from a normal table?
What is the difference between post-database commit and post-form commit?
What is connection pool in oracle?
What is meant by a deadlock situation?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Explain the use of control file?
What are the limitations of check constraint?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is an oracle database?
How to define and use table alias names in oracle?
What is the fastest query method to fetch data from the table?
What is a snapshot log?
How to use select statement to count the number of rows in oracle?
