How to use alias column name in where clause - Mysql February 25, 2014 Example SELECT name,count (*) AS count FROM `emp` WHERE count <5 Instead of the above use SELECT name, count(*) AScount FROM `book` WHERE condition HAVING count <5 Instead of WHERE clause use HAVING clause. Share Get link Facebook X Pinterest Email Other Apps Labels How to use alias column name in where clause - Mysql Share Get link Facebook X Pinterest Email Other Apps Comments
Comments
Post a Comment