sql help

• znkin

  Old Hand

  Points: 382

  More actions

  July 16, 2004 at 5:04 am

  #85919

  I have a table with CustomerId column(integer type) and a RegDate column(datetime type)

  I want to display a sql query which returns 1 row with 2 columns , one will be the count of the records in the table and other will contain the oldest datetime value from RegDate column

  Thanks

• rockmoose

  SSCarpal Tunnel

  Points: 4601

  More actions

  July 16, 2004 at 5:09 am

  #514807

  SELECT COUNT(*) AS NoOfRows, MIN(RegDate) AS OldestDate FROM Table

  /rockmoose

  
  You must unlearn what You have learnt