Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 33017 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / ashish raut
for 2nd highest price..............
SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails)
for 3rd highest Price........
SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails
where price<(SELECT max(Price)as MaxPrice from OrderDetails))
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is meant by cursor in sql?
what is a cursor? : Sql dba
how would you get the current date in mysql? : Sql dba
What is time based sql injection?
What is cursor in pl sql?
What is delete command in sql?
List the different type of joins?
how to return query output in html format? : Sql dba
How do I find duplicates in sql?
Why indexing is needed?
What is spool?
which operator is used in query for pattern matching? : Sql dba
What is scalar function in sql?
What is package in pl sql?
How does a trigger work?
