The maximum

Category: MS-SQL Server -> Difficult Problems Author: bz8511929 Date: 2009-12-12 10:04:28
 
bz8511929
2009-12-12 10:04:28
Time Price
2008-11-11 1:00 54.58936009
2008-11-11 2:00 11.55521728
2008-11-11 3:00 1.883345125
2008-11-11 4:00 39.84413049
2008-11-11 5:00 15.5939697
2008-11-11 6:00 54.95860565
2008-11-11 7:00 49.33314437
2008-11-11 8:00 21.84095584
2008-11-11 9: 00 97.4281333
2008-11-11 10:00 84.44930062
2008-11-11 11:00 4.393094639
2008-11-11 12:00 12.13761585
2008 - 11-11 13:00 19.07726396
2008-11-11 14:00 68.72455863
2008-11-11 15:00 87.40349548
2008-11-11 16:00 12.276071
2008-11-11 17:00 56.79177791
2008-11-11 18:00 49.3967408
2008-11-11 19:00 23.24553495
2008-11 - 11 20:00 19.68401185
2008-11-11 21:00 93.18480753
2008-11-11 22:00 87.53835433
2008-11-11 23:00 45.17814934

How to get the maximum price value, and its corresponding time, such as 97.4281333, 2008-11-11 9:00
very grateful