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 vote97 views1 answer
How to open mysql in docker
SQL
0 vote104 views2 answers
Pl sql auto increment
SQL
0 vote96 views1 answer
How to check which sp is running in sql server
SQL
3 votes106 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote101 views1 answer
How to install postgresql on wsl
SQL
2 votes97 views1 answer
Oracle index size calculation
SQL
2 votes120 views1 answer
Revokeprivileges mysql
SQL
8 votes113 views1 answer
Mysql restore database
SQL
5 votes107 views2 answers
Oracle find all tables with column name
SQL
0 vote116 views1 answer
Python connect to mysql in settings.py
SQL