Don’t use cat or any other tool which is not designed to do that. Use the program: nl – number lines of files Example: $ nl –number-format=rz –number-width=9 foobar $ nl -n rz -w 9 foobar # short-hand Because nl is made for it 😉
Postgresql > 8.4 SELECT row_number() OVER (ORDER BY col1) AS i, e.col1, e.col2, … FROM …
Take a look at this. Change your query to: SET @rank=0; SELECT @rank:=@rank+1 AS rank, itemID, COUNT(*) as ordercount FROM orders GROUP BY itemID ORDER BY ordercount DESC; SELECT @rank; The last select is your count.
For the first question, why not just use? SELECT COUNT(*) FROM myTable to get the count. And for the second question, the primary key of the row is what should be used to identify a particular row. Don’t try and use the row number for that. If you returned Row_Number() in your main query, SELECT … Read more
There is no ranking functionality in MySQL. The closest you can get is to use a variable: SELECT t.*, @rownum := @rownum + 1 AS rank FROM YOUR_TABLE t, (SELECT @rownum := 0) r so how would that work in my case? I’d need two variables, one for each of col1 and col2? Col2 would … Read more