select * from table where 3 2 what will return this query? anyone explain this query??

Question

Hi select * from table where 3 > 2 what will return this query? anyone explain this query??

Shankar M · Answer

Hi Joseph The where clause condition 3 >2 is satisfied and the query will return all the records from the table. We can write such query to create a table based on the existing definition of the table like CREATE TABLE tablex AS SELECT * FROM EMP WHERE 3 >2; The above statement creates tablex with all the rows from the emp table. If you need to copy only the structure of the existing table then you can query : CREATE TABLE tablex AS SELECT * FROM EMP WHERE 1=0; The above statement creates tablex with the definition of EMP table and with no rows.

Rohatash Kumar · Answer

Hi manuel In where clause 3>2 condition is true. It will return all the records of the table. If you write condition 2>3. This condition is false. It will not return any record from the table only structure of the table will be display.

Manish Dwivedi · Answer

Hi This query will return all the records of the table because condition is true in where clause you have written 3>2 which is always true.