I have table with name as table1 with 10 rows then what is the out put of
select * into table2 from table1 where 1=0
ans:
table2 is created with 0 rows
reason for no rows: the where condition 1=0 is always false so only table is going to created.
select * into table2 from table1 where 1=0
ans:
table2 is created with 0 rows
reason for no rows: the where condition 1=0 is always false so only table is going to created.
No comments:
Post a Comment