SQL distinct query with whole record -

How do I select all records from the table where the difference column value, I like it

< Pre> Select Table where DISTINCT col1, col2, col3 and S_Id = '20'; How can I find different values ​​for 3 columns ( col1, col2, col3

edit

code>) in the column called S_Id ?

[2] Then how can I select all the columns & amp; Rows from my table ( col1, col2, col3 ) are found in those specific values? (Where is the table from SELECT col0, col1, col2, col3, col4, ... col9? (where s_id = val))

I'm sure what you want, there are several ways to do this. Try it:

  SELECT a. * FGEHF_DB.dbo.Tbl_Alotee from a JOIN (Select MAX as ID) FGEHF_DB.dbo.Tbl_Alotee WHERE Plot_Id = '4117' - or other value AID = BID  

I think we are coming closer.