Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the output of this query selet * from employee
where 1=2 ??

Answer Posted / julien

indeed it will return o rows, but the goal behind is to
create a new table t2 as select * from t1 where 1=2, where
just the structure of table t1 will be copied without
copying data from table t1.

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 'mysqladmin' in mysql? : Sql dba

972


What is out parameter used for eventhough return statement can also be used in pl/sql?

1014


How is debugging done?

918


who introduced sql?

948


How do I truncate a sql log file?

1003


How do you respond to dementia behavior?

925


What is difference between inner join and cross join?

909


What is user in sql?

966


Is not null in sql?

926


What is partition in sql query?

946


what is row? : Sql dba

1166


How bulk collect improves performance?

946


what are the authentication modes in sql server? How can it be changed? : Sql dba

1320


Explain autonomous transaction.

1093


Enlist the characteristics of pl/sql?

1740