Select 1 from orders

select 1 from table will return the constant 1 for every row of the table. It's useful when you want to cheaply determine if record matches your where clause and/or join.

Source: stackoverflow.com

Similar codes

3 votes181 views1 answer
Pl sql check if variable is empty
SQL
0 vote286 views1 answer
Mysql select random rows large table
SQL
11 votes186 views2 answers
Insert date sql
SQL
0 vote356 views1 answer
How to use select union and loop
SQL
0 vote195 views1 answer
Mysql date + 1 day
SQL
0 vote205 views1 answer
Search from comma separated values in sql server
SQL
0 vote216 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
4 votes210 views2 answers
Bulk kill mysql processlist
SQL
0 vote200 views1 answer
Create or replace view postgress
SQL
11 votes185 views1 answer
Mysql order by two columns priority
SQL