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
- 20584 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
which are the query selection criteria, which can be given in a query?
Explain The Keywords Edtcde & Edtwrd?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
what is term cua , saa?
how can you execute a command from within an rpg program without calling a clp program?
what is the command used to invoke rlu ?
can a join logical file be updated?
how can we run a batch job?
Space & Skip Are Which Level Keywords?
Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out
which are the member types which seu supports?
what is the function of crtdupobj command?
What is array in as400? What are the types of array?
What Is The Object Type Of Pf, Lf, Printer File & Display File?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
