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

please guide how can I get top 5 ro

Status
Not open for further replies.
azeemkhn

azeemkhn

IS-IT--Management
Jan 15, 2020
6
0
0
QA
please guide how can I get top 5 rows of each item transaction. I have one table where 10 different items transactions exists with Item code, trandate and stock qty. I want to get top 5 record of each item based on transaction date.



 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
81
Cpreston
Cpreston
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
96
SarahSCPDAdmin
SarahSCPDAdmin
AleXSR700
  • Locked
  • Question
How can I make variable that is re-defined per section and readable in same-section formula? 2
2
Replies
20
Views
259
AleXSR700
AleXSR700
jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
93
BobSuruncle
BobSuruncle
cursedkorok
  • Question
Transpose Columns into Rows?
Replies
0
Views
56
cursedkorok
cursedkorok

Part and Inventory Search

Sponsor

Back
Top