Interested to Buy Any Domain ? << Click Here >> for more details...
What is the SQL query to select, delete and get count of
duplicate rows in DB2?
- 2 Answers
- 9408 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / igor kramov
DELETE FROM (
SELECT ROWNUMBER() OVER (PARTITION BY c1, c2 ORDER BY c3
DESC) AS rnum FROM t1)
WHERE rnum > 1 ;
the same is for Select\Count
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / hkhatri27
SELECT Columns
FROM Table
GROUP BY Columns
HAVING COUNT(*) > 1;
~ Himanshu
| Is This Answer Correct ? | 2 Yes | 2 No |
What information can you find in SYSIBM.SYSLINKS table?
Explain transactions, commits and rollbacks in DB2.
What is EXPLAIN?
What is database manager in db2?
can we update the table by using cursors can anyone post the query?
How can you find out the # of rows updated after an update statement?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is a plan and package in db2?
Name the lockable units in DB2?
What is db2?
Is it possible using max on a char column?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
COBOL 
