Contact

If you like a new Web or Desktop
application, update a existing one
or add new modifications. Your at
the right place and hit the
hire me button

Follow

If your intersted you can follow
me on Twitter by clicking here

Home
Web and Apps Building Refernce

World Wild Web

UNIX Apps AND Tips

Programming languages



Advanced SQL Query

Sun, 11/22/2009 - 13:17 — ndj
Advanced SQL Query

SELECT  ai.*
FROM    (
SELECT  DISTINCT  email
FROM    address
) ad
JOIN    address ai
ON      ai.id =
(
SELECT  id
FROM    address ao
WHERE   ao.email = ad.email
ORDER BY
(name IS NULL) + (address1 IS NULL) + (address2 IS NULL)
LIMIT 1
)