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

Answers were Sorted based on User's Feedback



what is the output of this query selet * from employee where 1=2 ..

Answer / asha

I Agree with Satya K
If the Table contanins the columns as
EMPLOYEE table
EmpNo Ename Salary
101 Hello 1000
102 hi 2000
103 dear 3000

When you execute the above query it gives only the
structure of the table...with the blank rows

Ans : EmpNO Ename Salary
is displayed

Is This Answer Correct ?    5 Yes 0 No

what is the output of this query selet * from employee where 1=2 ..

Answer / codecracker

No rows selected.

Is This Answer Correct ?    3 Yes 1 No

what is the output of this query selet * from employee where 1=2 ..

Answer / satya

Hi,

For the Query "No Records are displayed." because the
condition is false...The table displays ths structure..with
out the records if the table contains records also..


Regards
Satya.K

Is This Answer Correct ?    3 Yes 1 No

what is the output of this query selet * from employee where 1=2 ..

Answer / jana

here only the structure of the table is available and what
ever the data is there in the table is not copied into the
other table.

Is This Answer Correct ?    1 Yes 0 No

what is the output of this query selet * from employee where 1=2 ..

Answer / ajay

Just display only empty table structure

Is This Answer Correct ?    0 Yes 0 No

what is the output of this query selet * from employee where 1=2 ..

Answer / qaprofessional

This query would copy the structure, when the query is like
select into abc from xyz where 1=2 would result in the
structure of xyz getting copied to abc.

This query would return no values

Is This Answer Correct ?    0 Yes 0 No

what is the output of this query selet * from employee where 1=2 ..

Answer / rajendra

hai poonam i am rajendra

if you execute query like
selet * from employee where 1=2

here the where condition is meaningless

but you have selected all columns of data from table

it just displays all column names of table without data.

Not only where 1=2 for nay meaningless condition.

if you have still any doubt plz mail me i can send you
answers.

ok byeeeee

Rajendra Prasad Reddy
Mobile:+91-9885162742
Hyderabad.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Manual Testing Interview Questions

HI FRNDS, I HAVE 2 YEARS OF EXP IN MANUAL TESTING,PLZ LET ME KNOW IF THR R ANY OPPURTUNITES IN ANY COMPANY..ID:snehalatha83@gmail.com THANKS IN ADVANCE

3 Answers  


Hi friends This is sowmya plz can u tell me what type of questions will they ask in banking domain in interview plz let me know thanks in advance

1 Answers   CTS,


What is Bugzilla ?

2 Answers  


Expalin about metrics Management?

1 Answers   Fidelity,


What is Test Pack in software testing? OR What Test Pack consist of?

2 Answers  


How many days need to test one module?If any one know the answer please tell me?

2 Answers  


what kind of test cases we can automated.how to divide manual and automation test cases.

3 Answers   Wipro,


PLS SEND REAL TIMERS, WHAT IS SOA TESTING..IM TRYING 3+ YR.. I HAVE GOOD KNOWLEDGE ON MANUAL TESTING... NOW IM NEW TO LEARN "SOA TESTING" IS BEST OR NOT? BEFORE LEARNING SOA TESTING ANY SKILLS ARE REQUIRED..... AND NOW WHAT IS THE MARKET FOR SOA TESTING... AND IT IS BASED ON PROGRAMMING OR NOT?

0 Answers  


Who will Prepare the Tracebility Matrix?

4 Answers   Cap Gemini, Ramco, Wipro,


When ever u get a build, what type of environment u can deploy it?

4 Answers  


test cases on calculator

3 Answers   BMC, MNC,


what is the difference between sevierty and priority

3 Answers  


Categories