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 vote235 views1 answer
Sql server alter table add column tinyint
SQL
0 vote236 views1 answer
Show tables in cassandra cql
SQL
0 vote261 views1 answer
How to subquey to do not load in live database in
SQL
3 votes244 views2 answers
@sqlresultsetmapping
SQL
0 vote218 views1 answer
Sql where part of string match
SQL
0 vote242 views1 answer
Mysql where sum > 0
SQL
0 vote202 views1 answer
Describe in sqlite3
SQL
3 votes220 views1 answer
Select sequence oracle
SQL
2 votes262 views2 answers
Set value to null sql
SQL
0 vote223 views1 answer
Get a list of tables and the primary key
SQL