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!
Recent content by TomasGreif
-
Access & ROW_NUMBER function
Thanks for your response...What I want is not first n rows but something like this: SELECT CustomerID, ContactDate, ROW_NUMBER()OVER (PARTITION BY CustomerID ORDER BY ContactDate) AS ContactNo FROM CustomersContact; It's ranking within a subgroups of rows... I stil think it should be somehow...- TomasGreif
- Post #3
- Forum: Microsoft: Access Other topics
-
Access & ROW_NUMBER function
Hi, I can't find function, which is similar to ROW_NUMBER function in Oracle. This function is desribed below. Any idea will be helpful. Thanks. ROW_NUMBER is an analytic function. It assigns a unique number to each row to which it is applied (either each row in the partition or each row...- TomasGreif
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
