Loading

finding the highest version of data in sql server table

satish babu

13y1.5k

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

William Anthony13y ago
hello,

this query will work with varchar to find select max(version) from table name if version is having numeric/double/float datatype and if you enter strings in the version then it will return first highest charcter having highest ASCII value.

you can try: select max(version) from tablename
0