I need to create a view, about a ranking. The select from which I generate the view has a "ORDER BY" and I need to have a column in that select that shows the position of the object in that ranking.
I have searched on google, and I have found that it's possibile to do it using the SET command and using variables.. but I don't think in a VIEW I can use variables and SET. Any idea? Thanks. GF -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
