Interested to Buy Any Domain ? << Click Here >> for more details...
In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 24578 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / karthik
select dept,empid , count(*)
from table
goup by dept,empid
having count(*) > 1
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How can deadlocks be resolved?
Explain about dbrm.
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 a page in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is dclgen in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a buffer in memory?
Is ibm db2 free?
What is host variable?
What are types of indexes?
What is the usage of open cursor command?
How to find primary key of a table in db2?
What is universal database?
