InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:06:01 GMT20http://www.sqlservercentral.com/Forums/Topic954310-338-1.aspxIt's not clear to me what you're looking for.What rows do you want to return?Simple scenario:col1 col2A1 1A1 2A2 3A2 4What would be your expected output?Sat, 17 Jul 2010 02:34:44 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic954310-338-1.aspxi have a table with no unique fields but and when i use distinct for column1 then it gives 3000 rows or values but when i use distinct for all the fields then it gives 7000 rows. I want all rows related to the column one ie. i want to get distict all rows on basis of coloumn1 ie 3000 rows of all fields.currently i m useing query :select distinct * from table1 where column1 in (select distinct column1 from table 1).but this is giving 7000 rows but dustinct column1 is only 3000 rows.Sat, 17 Jul 2010 00:01:59 GMTscottichrosaviakosmos