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 the query select * from emp where 1=2

Answer Posted / suresh kumar somayajula

Hi Anfal,

Try the following Query.

SQL> CREATE TABLE EMP_NEW
AS
SELET *
FROM EMP
WHERE 1=2;
Table Created

SQL> SELECT * FROM EMP_NEW
no rows selected.

SQL> DESC EMP_NEW;
Structure will be displayed.

Please correct me if any mistakes.

Thank you,
Suresh

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name three reasons why the tester may choose to record in Context Sensitive mode.

2275


In cycle 1 we have 100 test cases out of which 95 test cases are PASS and 5 test cases are FAIL. So in cycle 2 how many test cases performed as a part of regression testing?

1569


What is neutral test case?

2214


Describe Testing Decomposition?

1253


hi, I m looking for a career in manual web testing. so PLZ anybody who have the practical knowledge of dis field help me. GIVE ME UR MAIL ID so that i can ask regarding some doubts. my MAIL ID is ankurtester819@gmail.com

1924


What is bug severity?

1113


i want to for technical interview question paper along with in tesrviwe Phases i need

1896


Information about Automated Software Installer

1914


What are bug leakage and bug release?

1188


What is localization testing (l10n testing)?

1198


value momentum

1736


I studied MBA, I want learn any softwarecourse, which course is better hadoop or testing tools(manual+selenium?)

1610


How should validation activities be handled?

1093


What is Catapult Testing in E-Learning Domain?

5162


What do you mean by Unit Testing, Integration Testing, System Testing, and User Acceptance Testing and when do you do them?

7943