Interested to Buy Any Domain ? << Click Here >> for more details...
write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 20846 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / kamal
hi,
select max(salary) from empfile where salary <(select max
(salary from empfile))
or
select salary from empfile a 2=(select count(salary) from
from empfile b where b.salary>=a.salary)
| Is This Answer Correct ? | 24 Yes | 2 No |
Post New Answer View All Answers
what is overlay?
which are the query selection criteria, which can be given in a query?
what is term cua , saa?
what is the maximum number of record formats in dspf?
under given circumstances, my cgi should link to another site. How to implement this?
what is the difference between sflclr and sflinz?
what is sflrolval?
. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?
what is elastic and non elastic subrile?
what is procedure prototype and procedure interface.
What are the mandatory keywords of sub file?
what is the disadvantage of using global variable?
give three main purposes of file specification ?
the maximum number of subfiles that can be active for a single file is ____ .
what is a composite key?
