/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 vote91 views1 answer
Insert thai language sql server
SQL
0 vote98 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote140 views1 answer
Sql pivot table
SQL
0 vote113 views1 answer
Neo4j command to run script file
SQL
3 votes102 views2 answers
Oracle for loop
SQL
8 votes108 views1 answer
Script to add datafile to tablespace
SQL
3 votes110 views2 answers
See mysql users ubuntu
SQL
1 vote154 views1 answer
Truncate table in postgresql and reset id
SQL
1 vote120 views1 answer
Insert value to new table by joining 2 different tables
SQL
4 votes103 views2 answers
Oracle last day of month
SQL