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

0 vote362 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote367 views1 answer
Mysql multiple primary keys
SQL
0 vote381 views1 answer
What is top n result in sql
SQL
0 vote348 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote356 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote311 views1 answer
Import csv to mysql
SQL
0 vote372 views1 answer
Get schema of table sql
SQL
6 votes410 views2 answers
Oracle trigger
SQL
9 votes370 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote387 views1 answer
Oracle sql first day of year
SQL