Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153807 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sam
Guys
See the correct answer.
select distinct sal from emp a where 4 =(select
count(distinct(sal)) from emp where a.sal <= sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Difference between oracle's plus (+) notation and ansi join notation?
What is integrity and what is constraint??Explain with example
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
interview questions with answer for cts
What are the predefined tablespaces in a database?
Which is better Oracle or MS SQL? Why?
Query to retrieve record for a many to many relationship ?
What is a connect identifier?
What is the difference between alert log file and tarce file ?
What is the difference between post-database commit and post-form commit?
What is truncate oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What are a collation and state the different types of collation sensitivity?
How to turn on or off recycle bin for the session?
What to do if dba lost the system password?
