Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 10116 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / pandu
To get the duplicate records in a table use the query
Select distinct(deptno) from emp;
reply any one to me am i correct.
| Is This Answer Correct ? | 2 Yes | 26 No |
Post New Answer View All Answers
What is dbrm library?
What is db2 and what is the use of db2 optimizer?
What is a page in db2?
What is schema in db2?
What is innodb buffer pool?
How would the varchar column remarks defined?
What is the use of runstats in db2?
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 ?...
Explain dclgen.
What are the different types of base tables?
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.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Define db2.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is iseries database?
