what is the output of the query select * from emp where 1=2

Answer Posted / ganesh

for sure it will display no rows selected
coz for select * from emp give all and because of the where
clause 1=2.......no point in time 1 is eual to 2 or 2 is
equal to 1....so it returns no row.

eg 1=2 ----give no rows
1=1 ---gives all rows
come out of oracle and think as simple logic (is 1=2)....if
yes true else false.....similar of oracle also

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?

1635


What is unit level testing?

673


tell me 5 new requirements in ur project? plz urgent

1974


What is an entry criteria?

665


.In languages testing, what is the fixed part and changing part?

1667






What type of questions will be asking for 2 years experience candidate in manual testing?

1812


What if the project isn’t big enough to justify extensive testing?

798


Which model is following in your company for developing software?

735


Hi Friends, Just One Month Back I was Join in Small Company as a Testing Eng.I have Six Month Exp. In this Company all my team memb.r fresher & PM give responsibility on us to prepare all require QC doc. for our new project.So I need ur help in this matter .How Can I start my work and Which Doc.I start to collect & From Where I get Detail Information all abt these thing. Thanks to all friends who give reply to this. Suyog

1446


what is prototyping model,RAD model V model, spiral model?????

5166


Give me sample test cases for smoke testing

8700


Describe your experiences with code analyzers.

1755


Give me an example of something you tried at work but did not work out so you had to go at things another way.

1665


what are metrics and what are metrics did u collect in you are project

1952


When to stop testing? (Or) how do you decide when you have tested enough?

658