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

How do you write an inner join query?

996


List the different type of joins?

1113


What is rownum?

1034


Differentiate pl/sql and sql?

1130


What is the usage of sql functions?

1206


Is pl sql a scripting language?

1082


How to sort the rows in sql.

1124


What will you get by the cursor attribute sql%rowcount?

1077


How to run pl/sql statements in sql*plus?

1147


Is t sql a programming language?

1114


Is microsoft sql free?

1142


What is the source code of a program?

1120


what are the types of join and explain each? : Sql dba

1088


How can you load multi line records? : aql loader

1126


What is raid? How does it help storage of databases?

1133