Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24311 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / ajay roy
The Correct answer is ---
select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)
Thanks Elumalai.k
Top Keyword returns the top(first) row not the max record
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of objects are there?
What is normalization 1nf 2nf 3nf?
ow to bring suspect mode datbase online from scratch
What are trace flags?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is store procedure? How do they work? When do you use?
What is the difference between upgrade and migration in sql server?
What is awe?
What is an execution plan?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
Mention the uses of stored procedures.
How do I find the sql server version?
What is SQL Azure Federations?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is subquery? Explain the properties of a subquery?
