select 'is true ' as condition
from dual
where 1=1 or 1=0 and 0=1;
Select 'There is No Dual '
Another condition:
SELECT 1=2, 1=1
The query to dual table in MYSQL return values, True: returns 1 and False returns :0;
| SQL_IS_TRUE1.htm |
| Oracle: PostgreSQL: |
| Script:
select 'is true ' as condition |
| Oracle dual , and dual equivalents in MySQL and PostgreSQL |
| Oracle:
|
| PostgreSQL :
Select 'There is No Dual '
Another condition: SELECT 1=2, 1=1
|
| MySQL:
The query to dual table in MYSQL return values, True: returns 1 and False returns :0;
|