what is the output of this query
selet * from employee where 1=2
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is pending/Rejected defect. Did ever come across such defect? Give example
what is quality Factor
What might be the reasons for changing the status of a bug to " NOT A BUG " ?
What is the difference between Smoke Test & Sanity Test?
10 Answers Qualtree Solutions,
Could you tell me two things you did in your previous assignment (QA/Testing related hopefully) that you are proud of?
write test cases on pen
what could be the (realtime)bugs you come across in job portal and health care projects in terms of 1. high severity n low priority 2. high severity n high priority 3. low severity n low priority 4. low severity n low priority? pls its very urgent thanks n in advance n lukin forward for reply
is there any openings in testing mba guys
through which phases a software ttester need to pass like as a junnior test engineer,team lead,project lead,etc.? which is the final stage of your promotion and how will u achieve?
Expalin about metrics Management?
is test data the same as test condition
How do you estimate staff requirements?