Header Ads Widget

Responsive Advertisement

Ticker

6/recent/ticker-posts

How to use of 1=1 & 1=2 in SQL query

Query and Description :

1. Select * into EMP_COPY from emp where 1=1;

Description : This query will create same table with data. 

2. Select * into EMP_COPY_2 from emp where 1=2;

Description : This query will create same table without data. 

Post a Comment

0 Comments