Answer Posted / a
select MAX(Salary) from Employee
WHERE Salary NOT IN (select MAX(Salary) from Employee )
Is This Answer Correct ? | 0 Yes | 9 No |
Post New Answer View All Answers
Is the primary key a clustered index?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is dpf in db2?
What type of database is db2?
What is a bind in db2?
Give the name of some fields form sqlca.
How to find the number of rows in a db2 table?
What is the difference between db2 and oracle?
Is db2 free?
Explain about rct in db2?
How to get the ddl of a table in db2?
What is dclgen (declaration generator)?
Mention the location where the output received from explain statement is stored.
Define data page.