VAdim,
Great work.
Keith.
disks=> select * from tracks t1 where t1.artist = (
disks-> select distinct t2.artist from tracks t2 where t2.trackno = (
disks-> select max(t3.trackno) from tracks t3
disks-> )
disks-> );
diskid|trackno|artist |song
------+-------+-------------+-----------------------------------
51| 1|Elvis Presley|Hound Dog
.
.
.
.
.
248| 25|Elvis Presley|The Wonder Of You
248| 26|Elvis Presley|Bridge Over Troubled Water
(73 rows)
disks=>
Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>
>
> Sorry, I decided to copy subselect' tuple unconditionally...
>
> Vadim