Can any one give answer for this question. Suppose im having
employee table with fields, eno, ename, dept, address1,
address2, address3. In address field employee can fill only
address1 or address2 or address3... at a time he can fill
three address fields. now i want all employee names who
filled only one address field.. Plz its urjent can any one
give querry.. Thanks in advance.
Answers were Sorted based on User's Feedback
Answer / raj
Select ename from employee
where (adress 1 is not NULL and (adress 2 and address
ISNULL)) OR (adress 2 is not NULL and (adress 1 and address
3 ISNULL)) OR (adress 3 is not NULL and (address 2 and
address 1 ISNULL))
| Is This Answer Correct ? | 29 Yes | 0 No |
Answer / nitin sharma
select ename from employee where adress2 and adress3 is NULL;
| Is This Answer Correct ? | 5 Yes | 13 No |
what is data base testing, explain with example
What is the good qualities of test enginner
What type bugs you will find in integration testing with example?
what is a Checklist
write test case for gmail sign up page ?
Define each of the following and explain how each relates to the other: Unit, System, and Integration testing.
Hi could some one please send me the testplan testcases(for 2Modules) and testscripts for mercry fliht aplication or gmail. please write those on templates and send me.In testplan plase write Testobjective, test scope, est approach, exlusions assumptios.
Hi frnds,im roopesh. i got job in an MNC company on FAQ experience(2.6yrs)..though i know the subject,but i dont know the real time process in a company. so pls can any one tell me vat is the work that i get first & what should i do ? in starting day ven i enter into company vat is environment there ? so pls frnds send the answer soon & give me support plzz..thanking u all.....
What is show stopper defect and explain with example ?
Who fixes the bug as Severity and priority ?
12 Answers Access, Aricent, Infosys,
what is crud testing ?
tell me some major and minor defects in ur net banking project?