Select highest version

Hello,

I have the following problem.

I have three Columns

name / version / package

I want to create a select query, that shows me all names and their actuall package. The actual Package is the record with the highest version number.

For Example my Database has the following entries :

name / version / package

name1 / 1 / package1
name2 / 1 / package1
name2 / 2 / package3
name3 / 1 / package2

The output should look like this :

name1 / 1 / package1
name2 / 2 / package3
name3 / 1 / package2


Has anyone a idea and can help me ?


Thanks in Advance

Mirco

are there going to be names that don't have a version 1? if not, then you could just do a simple

select

name,
version,
package

from

Table_name

where

version = 1

Hi, thanks for your answer, but i would have the names and packages with the highest version for each name



In my Example the name2 has two versions.

Mirco

Thanks that´s it

Mirco