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

How can I detect whether a given connection is blocked?

1041

---

Explain about the relational database?

1060

---

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

1012

---

What is dbms and its application?

996

---

What are the key features of dbms?

983

---

Explain about network model?

996

---

In which database can extended stored procedures be added?

893

---

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

1009

---

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

2154

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1002

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2846

---

Explain about the database management systems.

962

---

I have a few records all are same structures data, I want to store data in multiple targets how

2641

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

988

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

961

---