Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

What happens if we access a website that has cookies once the browser cookies are disabled?Does the website will be accessed?Though accessed, does the session will be tracked?

1 Answers  


how do u make severity , suppose login page has been sucessfully passed and entered in 2nd page instead of 1st page. what is ur reaction .

11 Answers   Amdocs,


I have 2 yrs 10 months experience in manual testing. there is a gap of 3 yrs in between. just 3 months before i rejoined the same company. I am looking for new & better job.What I have to enhance my career to up level, should I have to do Automation course or any other. Guide me properly.

0 Answers  


what is the diff b/n test plan and test strategy

3 Answers   CTS,


hi can somebody suggest standard format for web based testing? especially with numerous sublink to be tested. thanx

1 Answers  






Is dekstop testing and client-server testing same ?

1 Answers  


what is the similarity between black box testing and unit testing

7 Answers   CitiGroup,


What is a Regression testing? And do you follow that in your project?

7 Answers   IBM,


How many test scripts can you prepare per a day?

5 Answers   AppLabs,


Tell me the scenario where sevirity More and Priority Low?

10 Answers   Siemens,


Explain accessibility testing and its importance in the present scenario.

0 Answers  


what is test metrics? difference between test matrix and test metrics? (Asked in Zensar Hyderabad today(17-1-12010))

1 Answers   Zensar,






Categories