Can I run a select statement and get the row number if the items are sorted? I have a table like this: mysql> describe orders; +————-+———————+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +————-+———————+——+—–+———+—————-+ | orderID | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | … Read more
I want to use the ROW_NUMBER() to get… To get the max(ROW_NUMBER()) –> Or i guess this would also be the count of all rows I tried doing: SELECT max(ROW_NUMBER() OVER(ORDER BY UserId)) FROM Users but it didn’t seem to work… To get ROW_NUMBER() using a given piece of information, ie. if I have a … Read more
Is there a nice way in MySQL to replicate the SQL Server function ROW_NUMBER()? For example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY col3 DESC) AS intRow FROM Table1 Then I could, for example, add a condition to limit intRow to 1 to get a single row with the highest col3 … Read more
