Answers for "select in where clause sql server"

SQL
0

select query where in sql

SELECT * FROM Customers

 WHERE CustomerID=1;
Posted by: Guest on August-28-2021
0

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
Posted by: Guest on January-10-2021

Code answers related to "select in where clause sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language