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
Followers
Monday, 30 March 2015
Combination of distinct, select join gorupby orderby isNULL
Recommended Articles
- MYSQL
‘IF’ condition in ‘SELECT’ statement May 10, 2017
MySQL IF() takes three expressions and if the first expression is true, not zero and not NULL, it returns the second expression. Otherwise, it ret...
- Drupal
Web DevelopmentJun 16, 2016
WEB DEVELOPMENT is the backbone of our business. We create your Websites that attract users. We have the expertise, the experience and the knowle...
- MYSQL
MySQL PHPDec 28, 2015
This is a PHP programming tutorial for the MySQL database. It covers the basics of MySQL programming with PHP. It uses the generic mysql module. The ...
- Interview
MySql Interview QuestionsMay 05, 2015
Ques 1. Explain what Is MySQL? Ans. MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. ...
Newer Article
Download Megaflexible Responsive Magento Theme
Older Article
A Metro-Inspired Responsive Drupal Theme
Labels:
MYSQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment