Getting row numbers

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
claudiu111
Posts: 12
Joined: 2014-02-03 12:20

Getting row numbers

Post by claudiu111 » 2020-08-10 10:10

Hi,
I am trying to get a column that shows numbers for every row kind of like this:
  • row_nr id t1 t2 t3
    1 1 a b c
    2 3 d e f
    3 4 g h i
    4 6 j k l
    5 7 m n o
I tried adding this to a calculated field but it doesn't show anything:
set @row_n = 0; SELECT @row_n := @row_n + 1 as row_nr,ID,Name,Surname,PID,Age,Gender,Address,Email,Phone,Country,Other_country,Residence,Motivation,Skills,ICT_skills,Interactions,Specialization,GDPR
FROM Specialists
ORDER BY ID;

Can someone please help?
Thank you

Post Reply