Interested to Buy Any Domain ? << Click Here >> for more details...
if suppose i am having an ACCOUNT table with 3 coloumns ACC.
NO,ACC. NAME,ACC. AMOUNT . If a unique index is also
defined on ACC.NO and ACC.NAME then write a query to
retrieve account holders records who have more than 1 ACC.
- 8 Answers
- 11973 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / lol
select ACC.NO||ACC.Name from ACCOUNT having count(acc.no||acc.name) >1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How and when does the db2 enforces the unique key?
what is db2 restart?
How do I create a view in db2?
What is the use of with ur in db2?
Explain various types of locks in db2?
Explain package in db2 and its advantages?
Explain dclgen.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is buffer pool and list some of them?
Is db2 free?
What is a db2 cursor?
Which component is responsible for db2 startup and shutdown?
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 physical storage length of time data type?
How can the duplicate values be eliminated from db2 select?
