Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368641 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
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Is there any restriction on the use of union in embedded sql?
What is cost in sql execution plan?
What is the use of sql trace?
Is pl sql and postgresql same?
What is the difference between function and procedure in pl/sql?
how to include numeric values in sql statements? : Sql dba
What is sqlcommand?
Can you join a table to itself?
What are local and global variables and their differences?
what are sequences
Is sql better than excel?
Which query operators in sql is used for pattern matching?
Is pl sql a scripting language?
How do I remove sql developer from windows 10?
