Skip to Content
0
Former Member
Jul 05, 2006 at 11:18 AM

selecting maximum value of a column

392 Views

Hi All!

Can anybody give me the inexpensive select statement which gives the maxmimum value of that column.I am having a Z table and the column <b>version</b> in the table will have the following fixed value.

Y-1

Y-2

Y-3

Y-4

Y-5

Now everytime I run the report i have to select the maximum value of the version.Please advise,

Regards

Praneeth