Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

According to RBI rule how much money can be transferred through online banking at one time...?

2846


What is difference between Manual testing and Pega/BPM testing?

8129


how deployment phase of SDLC differs in product based and in service based company ?

2910


How do you estimate white box testing?

1077


What is Online gaming, payment gateway development, hosting and custom software development services.

1867


What are the bussiness scenories?

3353


Define Stability, Scalability and reliability with example ?

3154


Tell me the advantage and disadvantage of cookies?

1268


Define performance and stress testing?

1119


What is Test methodology, Testing type , Testing approach, Testing technique & Testing methods. Explain with example.

1911


What exactly is quality control? Is it similar to quality assurance?

1020


how to generate id in testdirector? a) Td id 1 b) td id 2 c) td id 3 d) td id 4 which is correct answer please any one of the tell me and mail me

2212


*) Internal review defect gets detected… 1) During peer review. 2) By the own stuff member onsite/offshore. 3) During Informal review process. 4) None of these 5) All of these

2226


When did u complete testing ? Which scenrio should not be in automation testing ? why ?

2963


If date field is a text field write test cases to validate it?

2417