Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368182 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 sql injection vulnerabilities?
Why commit is not used in triggers?
What is sql data?
what is try_catch block in procedure
What is error ora-01000: maximum open cursors exceeded
How is a PL/SQL code compiled?
How to write pl sql program in mysql command prompt?
What is difference between table and view?
How to fetch alternate records from a table?
What is difference between left and right outer join?
what is top in tsql? : Transact sql
What is sqlerrm?
What is sql injection owasp?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Why is a primary key important?
