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 / 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 |
Post New Answer View All Answers
Can you explain tailoring?
what are risks and contigencies(solutions) of an ecommerce (online shopping and bidding project)application?we describe this in Test plan can anyone tell me abt this?
What is Registry?
Can any tell me how a clinical data management system is tested? what are the test scenarios? what are the test cases? work flow.
What are drawbacks in system development life cycle
Hi Can any one tell wht type of questions will be asked in project manager round...urgent plz...
How we test the bulk of contents in web page using manual testing? Is any open source tool available for that ? Thanks in advance..
What is the test harness?
What is change request, how you use it?
What kind of input do we need from the end user to begin proper testing?
In a systen design to work out the tax to be paid: An employee has Rs 4000 of salary tax free. the next Rs 1500 is taxed at 10% , the next Rs 28000 is taxed at 22% , any further amount is taxed at 40% , the nearest whole Rs, which of these is a valid boundary value analysis test case ???? a)Rs 1500 b)Rs 32001 c)Rs 33501 d) Rs 28000.
Hi, This is vkram.I had completed my B.E in May 2005 & currently i am undergoing Testing Course. I want to join as a Fresher in any MNC. What should I tell why u r coming to testing field & what u did this 2 years?
Define brain stromming?
what is the difference between PEGA based web application testing versus web application testing?
Hi,friends i am going to write ICST certificate exam on augest.So can anybody post some of sample qusetions for ICST certificate exam.Really it will be useful for me