how to find the second highest salary from emp table?
- 211 Answers
- 322021 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / rakesh a.
select Amount from PurchaseOrderDetail pod where
1=(select COUNT(amount) from PurchaseOrderDetail pod2 where pod2.Amount>pod.Amount)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between microsoft access and sql server?
how to get a list of all tables in a database? : Sql dba
Why do we use sqlite?
How many joins can you have in sql?
What is the difference between inner join and left join?
How do you create a unique index?
What is t sql used for?
what is the syntax used for partition in tsql? : Transact sql
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How many sql statements are used? Define them.
How do I save a stored procedure?
what is log shipping? : Sql dba
What is pl sql and why it is used for?
How would you convert date into julian date format?
Can you upgrade sql express to full sql?
