Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151119 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / shashi kumar
Select * from emptable e1 where(N=(select
count(DISTINCT(e2.empsal))from emptable e2 where
e2.empsal>=e1.empsal))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to run create database statement again?
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.
How to list all indexes in your schema?
What are the differences between date and timestamp in oracle?
How to load excel data sheet to oracle database
Describe the types of sub query?
How to view existing locks on the database?
how to handle exceptions in post production
What is merge in oracle?
defination of bitmap index
How to declare a local variable?
Why cursor variables are easier to use than cursors?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain rename?
