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
- 20847 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / sandeep
select top 1 salary from employee where salary<(select top 1 salary from employee order by salary desc) order by salary desc
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how may a cgi control duplicate inputs?
different type of cursor?
What is data structure in as400? What is the use of data structure?
what is the maximum number of subroutines allowed in rpg?
Space & Skip Are Which Level Keywords?
what is the maximum number of fields under a record format of physical file?
when should I use method get, and when should I use method post in my cgis?
what is message subfile?
writing an sql statement from selecting records from two files using single statement and nested select statement.
define the rcvf command?
in conjunction with which statements can orxx and andxx conditions be used ?
can we define multi-dimensional arrays in rpg ?
define the purpose of the leave operation?
what opcode could be used to test an alphanumeric field for all numeric values?
what is the difference between seton lr and retrn?
