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 oracle sql developer?

1031


Where do we use pl sql?

986


Is a view faster than a stored procedure?

951


how to see the create table statement of an existing table? : Sql dba

992


Why should I use postgresql?

1003


Is sql developer case sensitive?

982


what are the advantages of using stored procedures? : Sql dba

1096


How do you modify a table in sql?

1109


What is a parameter query?

1062


How to read xml file in oracle pl sql?

899


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2008


how to use 'mysql' to run sql statements? : Sql dba

1040


Can function return multiple values in sql?

1036


Can you skip header records while loading? : aql loader

1026


What is the use of count (*) in sql?

1035