GET DATA BASED ON Multiple conditions

Question

I have a result set like this CHASSIS ENGINENO RES1 RES2 COLOR EXCISE DELDATE CHS21122015 EN21122015 1 0 NULL NULL NULL TESTCHS50011 EN50011 1 0 NULL NULL NULL CHS21122015 EN21122015 0 1 NULL NULL 1/8/201 5 TESTCHS50022 EN50022 0 1 NULL NULL 1/8/2015 TESTCHS50023 EN50023 0 1 NULL NULL 1/8/2015 TESTCHS50011 EN50011 0 1 NULL NULL 1/8/2015 RESULT SHUD BE CHASSIS ENGINENO RES1 RES2 COLOR EXCISE DELDATE CHS21122015 EN21122015 1 1 NULL NULL 1/8/2015 TESTCHS50011 EN50011 1 1 NULL NULL 1/8/2015 TESTCHS50022 EN50022 0 1 NULL NULL 1/8/2015 TESTCHS50023 EN50023 0 1 NULL NULL 1/8/2015

Ranjit Powar · Answer

Select * from TableName Where RES2=1 Union select * from TableName where CHASSIS not in(select CHASSIS from TableName where RES2=1)

Inam N · Answer

You didnt understand my question. Res1 and Res2 are 2 different columns and Highighted in yellow color. Can you see the table structure.Its not indented properly. Check the attachment for more details

Ranjit Powar · Answer

Select distinct CHASSIS ENGINRNORES1RES2 from table

Ranjit Powar · Answer

If mean to say if all three values are different then select record

Inam N · Answer

There are 2 different columns RES1 RES2 based on that I need.

Ranjit Powar · Answer

Select distinct CHASSIS ENGINRNO from table

CHASSIS	ENGINENO	RES1	RES2	COLOR	EXCISE	DELDATE
CHS21122015	EN21122015	1	0	NULL	NULL	NULL
TESTCHS50011	EN50011	1	0	NULL	NULL	NULL
CHS21122015	EN21122015	0	1	NULL	NULL	1/8/2015
TESTCHS50022	EN50022	0	1	NULL	NULL	1/8/2015
TESTCHS50023	EN50023	0	1	NULL	NULL	1/8/2015
TESTCHS50011	EN50011	0	1	NULL	NULL	1/8/2015