5 ms·

suprisingly often in real situations when I just want to get the columns of a table with no data I have done select * from table where (1=0)

• lgas 3y ago
  why not just `select * from table where false` ?
  • sixbrx 3y ago
    some databases such as Oracle do not support boolean literals or boolean at all as a user accessible type
  • codeulike 3y ago
    SQL Server doesn't have boolean literals like that, hence the (1=0) trick