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.
Answer Posted / nitin sharma
select ename from employee where adress2 and adress3 is NULL;
| Is This Answer Correct ? | 5 Yes | 13 No |
Post New Answer View All Answers
what is the difference between website and web based application ?
hi this is satish can some one help me out by sending the maxium notes on client sesrver ,web server and company architechture project hirearchy and company hirearchy i will happy to recive the answers as early as possible
What is a defect?
what is functional testing terminologies
What is performance tuning? What are tools of performance testing?
i have done B.E. computer in 2009 i have done software testing course and also 6 months exp in testing on live project as trainee, now a days i am searching job in pune. can any one tell me any opening in pune?
Assume a login page, and you have written 10 cases(say for example). How will you justify that these 10 testcase suffient for the login and how do you say this is 100% satisfies the need.
can anybody send the project you have tested with the clear descriptions,and recent bugs u found in that
Have you worked in UDAP (Credit Card act 2009) project?What did you test in Billing & Payment modules?
Can any body tell me in real time how cookies testing is done. And please tell me the steps.And for cookies testing test cases is needed.
what type of testing techniques are using after accept the build?
What is verification in software testing?
Can anyone tell me, What is wound fixing?
What is the difference between IE, Opera & Mozilla Firefox in web Testing and which brower will think that is much better?
what are the functional test cases for enter user name,enter pass word,click on ok(only functional test cases)