Answer Posted / lalithg

CREATE TABLE candytest
(kidId char(2),
candycolor varchar(10)
)
GO

INSERT INTO candytest SELECT 'K1', 'Yellow'
INSERT INTO candytest SELECT 'K1', 'Red'
INSERT INTO candytest SELECT 'K2', 'Red'
INSERT INTO candytest SELECT 'K2', 'Blue'
INSERT INTO candytest SELECT 'K3', 'White'
INSERT INTO candytest SELECT 'K3', 'Red'
INSERT INTO candytest SELECT 'K3', 'Yellow'
Go
--Now to find those kidid's which has both yellow and red
colored candies, we can write query as:

SELECT c1.kidid
FROM candytest AS c1 JOIN candytest AS c2
ON c1.candycolor = 'Red' AND c2.candycolor = 'Yellow'
AND c1.kidid = c2.kidid

Explain about relational database management systems?

1007

---

Explain what a database is?

1081

---

What are the three basic rules which are to be followed for the relational model of the database?

1066

---

Explain about normal forms?

1104

---

Explain about xml databases?

1108

---

Which four data types cannot be used as a return type from a user-defined function?

1058

---

explain detail about ftp in datastage?

2284

---

Explain about the database management systems.

1021

---

State the acid rules?

1174

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2076

---

How to generate OIDS

2326

---

What is database design and development?

1059

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2202

---

How to replace not in with not exist?

2171

---

Can an extended stored procedure be called from inside a user-defined function?

1108

---