Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DarthEvader
- Content: Threads
- Order by date
-
Select Most Recent Rows Per Month
I have a table where each row contains a single day's pricing information. The table has one row per "price date", going back to May of 2002. Example: UNIQUE_ID, TICKER, NAME, PRICE_DATE, PRICE A1234, TICKER1, Company 1, 5/5/2007, 12.5523423 A1235, TICKER2, Company 2, 5/31/2007, 1423.2342 I...- DarthEvader
- Thread
- Replies: 2
- Forum: Sybase: Adaptive (SQL) Server
-
Select Most Recent Rows Per Month
I have a table where each row contains a single day's pricing information. The table has one row per "price date", going back to May of 2002. I am trying to figure a way to select the row of the final "price date" of every month. The problem is that the final price is not always on the last...- DarthEvader
- Thread
- Replies: 5
- Forum: ANSI_SQL
