Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-04 : 11:09:47
|
| John writes "We have data similar to stock market data and want to consolidate it into a high-low-close graph. For sake of discussion, assume the table has two columns, a timestamp and a value. Getting the high (Max) and low (Min) are obvious, but how can we get the close (the last record for each time interval)? We would like to avoid subqueries for performance reasons if at all possible." |
|
|
|
|
|
High-Low-Close graph