Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bhaskar reddy
select * from table1 a where(n-1)= (select count(distinct
sal) from table1 b where b.sal>a.sal)
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the use of predicate?
What does db2 mean?
Explain in detail about buffer manager and its functionalities?
How to find the number of rows in db2 tables?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How does cobol compile db2 program?
What is db2 catalog database?
What is the difference between cursor and select statement?
Define db2.
How do you concatenate the firstname and lastname from emp table to give a complete name?
How do you eliminate duplicate values in db2?
What is the role of the data page in the db2 database?
How does db2 sample database connect?
How to take backup of table in db2?
