Group by Query----to also include respective record details

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my query I would like to see the Security Number (I used Group by
this)----Last Trade Time (I used "max" for this one) -----but I also want it
to include the respecitve information for the last trade----Volume and Price.
I've managed to isolate the the Security Number so each is unique, and
identified the Last trade of the day, but how can I get it to also show the
other two fields----for that trade?

MFR
 
MFR said:
In my query I would like to see the Security Number (I used Group by
this)----Last Trade Time (I used "max" for this one) -----but I also want
it
to include the respecitve information for the last trade----Volume and
Price.
I've managed to isolate the the Security Number so each is unique, and
identified the Last trade of the day, but how can I get it to also show
the
other two fields----for that trade?
Click to expand...
one way:
(replace "yurtable" w/ name of your table)

SELECT
[Security Number],
[Last Trade Time],
Volume,
Price
FROM
yurtable
WHERE
[Last Trade Time] =
(SELECT
Max(t.[Last Trade Time])
FROM
yurtable As t
WHERE
t.[Security Number] = yurtable.[Security Number]);

the advantage of putting the aggregation
in the WHERE clause should get you an
updateable query....
 
Back
Top