/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

0 vote199 views1 answer
Add sqlite3 in lumen
SQL
2 votes261 views1 answer
Merge two columns in sql oracle
SQL
0 vote217 views1 answer
Update sqlite
SQL
0 vote190 views1 answer
Ms Sql set us timezone
SQL
0 vote196 views1 answer
What is metadata in sql
SQL
1 vote203 views1 answer
Name of today sql
SQL
3 votes215 views2 answers
How to delete git repo locally
SQL
2 votes210 views3 answers
Sql interview query questions
SQL
2 votes188 views2 answers
Spring import sql
SQL
2 votes213 views1 answer
Power query concatenate
SQL