/SQL/Sql query use select name inside where clause

Sql query use select name inside where clause

You can not use aliased columns in a WHERE clause. You can try using a derived
table. Perhaps something like this (sorry, not tested):

select tblProgram.POIname from tblProgram
where 
  -- Use this if you only want to filter by the value.
  (select count(*) as alias_name from `fb_promo_codes_used`) < 2

Similar codes

23 votes135 views4 answers
How to uninstall postgresql in ubuntu
SQL
4 votes142 views1 answer
Sql quote in string
SQL
0 vote153 views2 answers
Plpgsql
SQL
0 vote122 views1 answer
First mysql
SQL
0 vote122 views1 answer
Mysql add comment to column
SQL
0 vote141 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote147 views1 answer
Php select data from mysql database without column name
SQL
4 votes92 views1 answer
Oracle sleep
SQL
-1 vote136 views1 answer
How to change the auto increment in existing table mysql
SQL
1 vote126 views2 answers
Mysql spring boot application.properties
SQL