Floris | 13-09-2011 | Hi, I hope somebody can help. I have done a simmilar thing as the above. I used it to find duplicates based on several collumns by adding count* > 1. But now i want to show rows that are in these groups. How can I do that? |
khan150 | 21-09-2011 | Floris,
suppose you are trying to find dup records in the table above. This should help
SELECT d_id, count(d_id) as numofoccurrence
FROM documents
GROUP BY d_id
HAVING count(d_id) > 1
this will display the d_id of the record and number of times its repeating. if you want to see the entire record, add more columns after select and group by respectively |
Ambas | 02-03-2013 | if can want to ask, i have 2 tables, in the have the same name of field and how i can call form text data to the combobox with php? thanks.
|
smo123 | 11-04-2013 | Along with table name you can call the columns like this.
select table1.name1, table2.name1 from table1, table2 where table1.id=table2.id
Here both tables have same column name name1 and id |
Vineet | 11-08-2014 | This is very helpful information to read in short time.
Thanks to author. |
|