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 |
|
endsabruptly
Starting Member
12 Posts |
 Posted - 2005-02-17 : 17:31:09
|
| My table has 3 primary keys: ACCT_NUM, PREMISE, and YEAR. It also has four other fields: DISPO_CODE, INSERT_USERID, INSERT_DATE, INSERT_TIME.I need to get a total count of like DISPO_CODE, but only of the most recent INSERT_DATE and INSERT_TIMEfor each ACCT_NUM, PREMISE, and YEAR.I have been working and re-working this for prolly 2 hours...now I need help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-17 : 17:32:53
|
| You've posted your question in a Microsoft SQL Server forum, so we'd be providing T-SQL answers. I would post your question over in the Oracle forum at dbforums.com:http://www.dbforums.com/f4Tara |
 |
|
|
|
|
|
ORACLE SQL SYNTAX HELP