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

1 vote134 views1 answer
Select from describe sql
SQL
0 vote126 views1 answer
How to declare variable date in mysql
SQL
0 vote183 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote131 views1 answer
Mysql select row with min date
SQL
0 vote137 views1 answer
Sql query tags
SQL
1 vote116 views1 answer
Update mysql centos
SQL
0 vote120 views1 answer
In mysql workbench contnent not feching
SQL
0 vote134 views1 answer
Add super privilege mysql
SQL
3 votes128 views1 answer
How to check schema privileges in oracle
SQL
0 vote131 views1 answer
UNION ALL LEFT JOIN
SQL