var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sequence No.
How can I generate a sequence No. using a simple SELECT statement.
set @key = 1
SELECT @key, e.name from Employee
Now I want to display name of the employee and Key value which should get incremented automatically for each employee..
Is there any way?
Please help me..
select RecordNumber=count(*), e.name from Employee e inner join Employee e1 on e.Key >= e1.Key
group by e.Key
order by 1, e.name