|
SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
24. 05. 2014. | #1 |
Ivan Dilber
Sir Write-a-Lot
|
Kako dohvatiti count() iz subquery-ja?
Trazim duplicate records, ali mi treba da znam i koliko duplikata ima za svaki (plus bi bilo dobro da po tome uradim ORDER BY).
Za sad imam ovakav upit koji nalazi sve usere koji imaju isti payment email: Kôd:
SELECT u.`id`, u.`username`, u.`email`, u.`first_name`, u.`last_name`, mb.`moneybookers_email` FROM users u JOIN `payment` mb ON u.id=mb.`user_id` WHERE mb.`moneybookers_email` IN ( SELECT `moneybookers_email` FROM `payment` GROUP BY `moneybookers_email` HAVING count(*)>1 ) ORDER BY mb.`moneybookers_email`
__________________
Leadership is the art of getting people to want to do what you know must be done. |
|
|