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 vote129 views1 answer
Mysql show table character set
SQL
14 votes149 views4 answers
Online sql compiler
SQL
0 vote160 views8 answers
Sql to c# linq converter online
SQL
10 votes129 views5 answers
Mysql create user
SQL
0 vote137 views1 answer
Get role postgres
SQL
-1 vote134 views1 answer
Partial search in sql
SQL
0 vote134 views1 answer
Sql offfset
SQL
0 vote140 views1 answer
Join in update query in mysql
SQL
1 vote125 views1 answer
Customer using hdfc bank sql query
SQL
-1 vote129 views2 answers
Get day in sql
SQL