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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select first complete row from each group

Status
Not open for further replies.
Aurillius

Aurillius

Programmer
Jun 3, 2004
60
CA
Hi,
I'm trying to create this query in Informix that will return the first row from each of these "Appt"'s. I originally wanted to find the minimum date but unfortunately, there are multiple PO's and Appt's that have the same date. I know that this should probably be simple but I can't seem to get it. Help!

Mark


Appt PO Date
1 1050422199 11/2/2017
1 4050407179 11/2/2017
1 4050407187 11/2/2017
1 1050422172 11/3/2017
1 1050422185 11/4/2017
2 4150393598 11/2/2017
3 4050407178 11/2/2017


Return:

Appt PO Date
1 1050422199 11/2/2017
2 4150393598 11/2/2017
3 4050407178 11/2/2017

 
Sort by date Sort by votes
I found something that I could use to achieve this...I'll share with the forum.

ROW_NUMBER() over (partition by appt order by Date asc)

Wrap another query around this and choose where row=1

Mark
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
357
arunkumar.ceg
arunkumar.ceg
KaronW
  • Locked
  • Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
273
KaronW
KaronW
evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
292
evgeniosc
evgeniosc
enriquegm82
  • Locked
  • Question
getting username from an informix 4gl program 1
Replies
3
Views
552
PHV
PHV
Stinney
  • Locked
  • Question
Select from Select? 1
Replies
4
Views
289
Stinney
Stinney

Part and Inventory Search

Sponsor

Back
Top