Uusing MAX() function

harpreetnc

I have a select statement like
select air_date, air_time , id, title and some more fields.

The title and air_date fields are dublicates for some records and i would like to return only the latest record with identical title and air_date.

Not sure how to do this. let me know thanks

amitpatel66

Quote:

Originally Posted by harpreetnc

I have a select statement like
select air_date, air_time , id, title and some more fields.

The title and air_date fields are dublicates for some records and i would like to return only the latest record with identical title and air_date.

Not sure how to do this. let me know thanks

You can get MAX on air_date group by flight no or some other column which will give you the data as you require!!

Uusing MAX() function

re: Uusing MAX() function

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about