satish babu

satish babu

  • 1.1k
  • 633
  • 85.7k

finding the highest version of data in sql server table

May 25 2013 2:05 AM
Hi all,hi i have small doubt.I have table like this

 column name      datatype
 -----------------    ----------------
    date               date
    version           varchar(50)
     name1           varchar(50)
   
     date       version   name1
  25/5/2013 1.1           A
  25/5/2013 1.2           B
  24/5/2013 2.5           C
  24/5/2013  2.0          D
 
I want to find the max version record of that day.Can u give me any suggestion abt to find the max vesrion of record?

Answers (1)