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 vote283 views1 answer
Oracle split string
SQL
0 vote313 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote366 views2 answers
Insert data into multiple tables mysql
SQL
3 votes304 views2 answers
How to delete git repo locally
SQL
28 votes294 views6 answers
Mysql change user password
SQL
0 vote278 views1 answer
Why mysql is used?
SQL
5 votes306 views4 answers
Start postgres server
SQL
8 votes293 views1 answer
Today minus 15 days postgresql
SQL
8 votes299 views1 answer
Oracle create datafile
SQL
4 votes367 views1 answer
How to check last gather stats on table in oracle
SQL