RE: Challenging query....

[Diana Soares]

On Thu, 2003-10-16 at 17:42, Jeff McKeon wrote:
> Is there a way to generate a "line number" for a query return within the
> returned rows??
> 
> For instance, if I return 5 rows from a query, is there a command or
> function I can put in a query to add a column that contains the row
> number returned?
> 
> Select some_command(),blah, blew from table where blah > 1;
> 
> +-----------+-----------+-----------+
> | row		| blah	| blew	| 
> +-----------+-----------+-----------+
> | 1		| blah	| blew	| 
> | 2		| blah	| blew	| 
> | 3		| blah	| blew	| 
> | 4		| blah	| blew	| 
> +-----------+-----------+-----------+

You can do:

SELECT @a:=0;
SELECT @a:=@a+1, blah, blew from table where blah > 1;


-- 
Diana Soares