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 vote194 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote185 views1 answer
How to execute stored output to csv files
SQL
0 vote188 views2 answers
What is the default password for sql server sa
SQL
0 vote187 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
7 votes195 views3 answers
How ot change name of column mysql
SQL
7 votes183 views3 answers
Foreign key oracle
SQL
8 votes185 views1 answer
Oracle all_source package body
SQL
5 votes189 views1 answer
Sql select ciunt
SQL
0 vote183 views1 answer
PGSQL dynamic table name
SQL
0 vote182 views1 answer
Get number of tables in database sql
SQL