Ajayendra Raghuvanshi

I have a case where there are many rows for the same ID, I just wanted to know if there is any way to find out whether the given ID includes some specific value or not. Table 1 ID Dept Salary Flag Date 1 IT 5000 N 2017-01-01 1 IT 5000 N 2017-01-02 1 IT 5000 N 2017-01-03 1 IT 5000 N 2017-01-04 1 IT 5000 N 2017-01-05 2 HR 4000 N 2017-01-01 2 HR 4000 N 2017-01-02 2 HR 4000 Y 2017-01-03 2 HR 4000 N 2017-01-04 2 HR 4000 N 2017-01-05 3 Fin 4500 N 2017-01-08 3 Fin 4500 N 2017-01-09 3 Fin 4500 N 2017-01-10 3 Fin 4500 N 2017-01-11 3 Fin 4500

In sqlserver, when you have multiple data with some column have null value and you need the row which not null. So this example will help you. CREATE TABLE Family ( ID int , Name varchar ( 20 ), Gender char ( 1 ) ); INSERT INTO Family VALUES ( 1 , 'Ram' , 'M' ), ( 2 , 'Suraj' , 'M' ), ( 3 , 'Sunitha' , 'F' ), ( 4 , 'Deepika' , 'F' ), ( 5 , 'Minakshi' , 'F' ), ( 6 , 'Somu' , 'M' ); CREATE TABLE Child_parent ( Child_ID int , Parent_ID int ); INSERT INTO Child_parent VALUES ( 1 , 2 ), ( 1 , 3 ), ( 4 , 5 ), ( 4 , 6 );   Expected Result : Child_ID ChildName FatherName MotherName -----------------------------------------------   1         Ram       Suraj      Sunitha  4         Deepika   Somu       Minakshi Query to get Desire result with self join as below. SELECT cp . Child_ID ,