Interested to Buy Any Domain ? << Click Here >> for more details...
how will i display the duplicate record's from a table...
i don't want to eliminate ...i want to display the duplicate
record...for example in my table i have 10 record's like
record no(1,2,3,4,2,9,6,1) in this ...so i want to receive
duplicates...
- 1 Answers
- 5867 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / raja_kb
SELECT <Column Name1> FROM Table
GROUP BY <Column Name1> HAVING COUNT(*)>1;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is db2 command?
What is the function of logging in the db2 database?
What is the role of data manager in the db2 database?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is db2 bind process?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
can all users have the privilage to use the sql statement select * (dml)?
How to check last update on table in db2?
What is the maximum length of sqlca?
What is cloudant database?
What is the max length of sqlca?
What is meant by explain?
What is the advantage in De-normalizing tables in DB2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How to get the ddl of a table in db2?
