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

2 votes111 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
9 votes126 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote124 views1 answer
Show the colums of table sql
SQL
0 vote119 views1 answer
Mysql match in serialized data
SQL
0 vote108 views1 answer
2020 new year
SQL
0 vote74 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote113 views1 answer
Sql find record cannot cast date
SQL
6 votes113 views1 answer
Phpmyadmin password root
SQL
1 vote130 views1 answer
Importance of comment in mysql
SQL
3 votes172 views1 answer
Apex call duration
SQL