Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373168 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 syntax error and runtime error?
Is left join same as inner join?
what is the difference between myisam static and myisam dynamic? : Sql dba
What are the steps for performance tuning.
How do we accept inputs from user during runtime?
How to execute a stored procedure?
What does closing a cursor do?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is an example of translating a date into julian format?
what is the functionality of the function htmlentities? : Sql dba
Is postgresql a nosql database?
How do you truncate?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is indexing oracle sql?
What is Difference Between Unique and Primary Key Constraints?
