/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 vote185 views1 answer
Groupby sort sql hive
SQL
0 vote163 views1 answer
Sql how to display two atributes as one in sql
SQL
1 vote181 views2 answers
Sql where is not number
SQL
3 votes290 views6 answers
Sql unique select
SQL
0 vote188 views1 answer
Apache Derby: Create SQL Dump with data
SQL
1 vote164 views1 answer
Sql delete all values in a column
SQL
0 vote162 views1 answer
Postgresql get current user name
SQL
0 vote161 views1 answer
Access refused mysql xampp server
SQL
3 votes153 views3 answers
Print in pl sql
SQL
9 votes192 views6 answers
Check constraint in sql
SQL