Monday, 30 March 2015

MYSQL Combination of distinct, select join gorupby orderby isNULL

Combination of distinct, select join gorupby orderby isNULL

by shashank on 3/30/2015 02:11:00 am in MYSQL

SELECT DISTINCT h.h1_id FROM table h LEFT JOIN table ph ON h.h1_id = ph.h1_id WHERE isNULL( ph.id ) group by h2_id order by count(h.h1_id) desc

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Designed with by shashank | Distributed By shashank