SQL to add ordinal to query result

Situation: When programming with Delphi7, want to give the result of the query a number, for example, there are 10,000 results, the initiative from 1 to 10000

The data is displayed with the DBGrid control, but its first column is not very good to display the number, find a lot of methods can not be desired

After choosing Stringgrid, the first column shows the serial number, the effect reached, but there is no dbgrid speed.

Finally, it uses the method of displaying the query result number after the query is still using DBGrid.

Method: 1. DBGrid new Add a Field,field name as ID, this field does not exist in your table.

2.SQL. Add (' SELECT ID = Row_number () over (order by time), time, a,b,c,d,e from weight WHERE year (time) =2014 ');

Show:

SQL to add ordinal to query result