Thank you Mr. Jo Patyn  and Mr. Sameer Raval  for your information. It worked...

Thank You very much

Saiju

Your query is working but i cannot display the other fields of the grouped items.

Table Structure

Table name: Stock

Co_id char

open   float

High  float

Low float

Close float

date1   date 

Eg:

Co_id  date1         Open  High   Low 

101   10/01/2005  101    102   102

101   10/02/2005  201   ...

Your query is working but i cannot display the other fields of the grouped items.

Table Structure

Table name: Stock

Co_id char

open   float

High  float

Low float

Close float

date1   date 

Eg:

Co_id  date1         Open  High   Low 

101   10/01/2005  101    102   102

101   10/02/2005  201   ...

Your query is working but i cannot display the other fields of the grouped items.

Table Structure

Table name: Stock

Co_id char

open   float

High  float

Low float

Close float

date1   date 

Eg:

Co_id  date1         Open  High   Low 

101   10/01/2005  101    102   102

101   10/02/2005  201   ...

if more than two fields then how can i group

i tried with the below query it giving cartition product result

"Select data1,data2, max(datecol) as datecol from dbo.YourTable group by data1.data2"

Hello RGR'us,

 It is a good idea thank you very much

Saiju Thomas

Thank You Very much ......

It is working

Saiju Thomas