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 / ashokkumar

create table temp_employee as select * from employee where 1=2;
this is only for a correct answer..
it is create from a temporary table in same table name.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a recursive stored procedure?

1253


How can use stored procedures in sql?

1193


How do I debug a stored procedure?

1171


How to take user input in pl sql?

1207


How do I run a program in pl sql?

1055


Why are sql stored procedures used?

1098


which tcp/ip port does sql server run on? : Sql dba

1084


Is ms sql traffic encrypted?

963


What is dml and ddl?

1011


What happens when a trigger is associated to a view?

973


What is the order of sql select?

1088


How to disable a trigger name update_salary?

1316


Which sql most popular?

1031


Can we update views in sql?

990


how to create a new view in mysql? : Sql dba

989