Answer Posted / channabasappa
select field name from tablename where group by field name
having count(field name)>1;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the function done by data manager?
What is explain plan in db2?
What is the role of the data page in the db2 database?
What are the rules for db2 programming?
What is dclgen in db2?
what is a corelated subquerry?
What is rct?
Explain package in db2 and its advantages?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What do you mean by commit and rollback?
What is precompiler in db2?
How many types of page locks can be held in db2?
What kind of database is db2?
How to fetch the last row from the table in SQL (db2)?
What is a cursor in programming?