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 identity column in sql server?

1035


What is the difference between left outer join and left join?

978


Is inner join same as self join?

1107


What are the various levels of constraints?

1115


What are functions in sql?

936


explain the difference between myisam static and myisam dynamic. : Sql dba

927


what are set operators in sql? : Sql dba

1023


Is a view faster than a stored procedure?

948


In pl/sql, what is bulk binding, and when/how would it help performance?

982


What is an exception in PL/SQL? What are the two types of exceptions?

1278


What are reports usually used for?

1008


What are the different types of functions in sql?

1037


What is your daily office routine?

2256


what is index? : Sql dba

990


Is truncate ddl or dml?

976