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

4 votes160 views3 answers
Order by value mysql
SQL
0 vote186 views1 answer
Limit in access query
SQL
0 vote187 views2 answers
Call to undefined function mysql_query()
SQL
2 votes169 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote219 views1 answer
How to use sqlcommand
SQL
0 vote181 views1 answer
Start stop mysql linux
SQL
3 votes160 views1 answer
Sql timestamp to date
SQL
4 votes213 views1 answer
How to drop a database in sql server when it is in use
SQL
3 votes178 views1 answer
How to uninstall microsoft sql server
SQL
12 votes176 views4 answers
How to take database dump in postgresql
SQL