title: How to get only one value from data base colum that has multiple same values?
body: <p>I'm working on outputting values from data base in the table. My table has 5 columns: Date, FirstName, LastName, City, State. Here is example of my data base table: </p>
  
  <pre><code>DateMeeting  FirstName LastName   City     State
  2015-12-11    Mike     Johns     Dallas    TX
  2015-12-11    John     Cook      Dallas    TX
  2015-12-11    Nick     Roberts   Dallas    TX
  2015-12-11    Oliver   Ryan      New York  NY
  2015-12-11    Michael  Best      New York  NY
  2015-12-11    David    Holmes    New York  NY   
  </code></pre>
  
  <p>So I want to have output table that will display just one date for multiple records. I tried to use DISTINCT on the date and that works fine but if I include my WHERE clause for City and State my query breaks. Also I tried to use GROUP BY but same problem, I can get Date values only once as long as I do not include other columns. In this case I need all columns but my Date value only once. Here is my query that I use:</p>
  
  <pre><code>Select Distinct(DateMeeting),FirstName, LastName, City, State
  From Customers
  Where City = 'Dallas'
  and State = 'TX'
  </code></pre>
  
  <p>This query does not work with all columns that I have in my select, only if I run DISTINCT(DateMeeting). I would like to output my values in the table to look like this: </p>
  
  <pre><code>Date       First Name Last Name   City     State
                Mike     Johns     Dallas    TX
                John     Cook      Dallas    TX
                Nick     Roberts   Dallas    TX
   2015-12-11   Oliver   Ryan      New York  NY
                Michael  Best      New York  NY
                David    Holmes    New York  NY
  </code></pre>
  
  <p>If anyone knows how this can be done please let me know. Thank you.</p>