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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Max Timstamp / Effective Date

Status
Not open for further replies.
PhatMackn02

PhatMackn02

MIS
Jan 17, 2006
1
US
Hello, I am attempting to retrieve the most recent row or the most recent date in a query, I have used this custom SQL code and for some reason still retrieve a an extra row (Unique rows are not the matter):


Ps_Stdnt_Fa_Term.Effdt = (SELECT MAX(C_Date.Effdt) FROM Ps_Stdnt_Fa_Term C_Date WHERE Ps_Stdnt_Fa_Term.Effdt = C_Date.Effdt AND Ps_Stdnt_Fa_Term.INSTITUTION = C_Date.INSTITUTION
AND Ps_Stdnt_Fa_Term.Strm = C_Date.Strm)
 
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Passing a date via the WorkFlow Variables
Replies
1
Views
96
PWise
PWise
cariengon
  • Locked
  • Question
Essbase 6.5 Export Level 0, but using a date range.
Replies
0
Views
99
cariengon
cariengon
sa0309
  • Locked
  • Question
Date Format Conversion
Replies
1
Views
118
rasETL
rasETL
MINIACS
  • Locked
  • Question
"Invalid date, time or timestamp" error - Pervasive 10
Replies
0
Views
67
MINIACS
MINIACS
btellington
  • Locked
  • Question
Need help with Salesforce Date issue
Replies
4
Views
103
btellington
btellington

Part and Inventory Search

Sponsor

Back
Top