Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367689 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 are the two types of exceptions in pl/sql?
What are stuff and replace function?
how to start mysql server? : Sql dba
What is the difference between Union and Union all. Which is faster.
Why is sql important?
What is difference between hql and sql?
what is sql in mysql? : Sql dba
What is linq to sql?
What programs use sql?
Can two tables have same primary key?
Is join an inner join?
What is difference between rank () row_number () and dense_rank () in sql?
Why stored procedure is faster than query?
What are basic techniques of indexing?
Which data dictionary views have the information on the triggers that are available in the database?
