/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

1 vote284 views1 answer
Pagination sql
SQL
3 votes270 views1 answer
Sql multiple column index
SQL
0 vote325 views1 answer
Remove mysql from centos 7
SQL
5 votes306 views4 answers
Start postgres server
SQL
1 vote284 views1 answer
Insert column after column mysql
SQL
12 votes327 views6 answers
Change mysql root password
SQL
16 votes282 views2 answers
Oracle ddl
SQL
-2 votes287 views1 answer
Remove root password mysql
SQL
8 votes287 views2 answers
Safe update mode in mysql
SQL
1 vote317 views1 answer
Ora-01109 database not open in oracle 19c
SQL