finding the highest version of data in sql server table
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)
0