79654970

Date: 2025-06-05 17:47:49
Score: 1
Natty:
Report link

Use =>
1 row_number() OVER () to print row number for all records
2 -t removes header and footer

See example below

I have a table users in my database

Fetching 5 records from users table

enter image description here

removing column names with -t option

enter image description here

adding row number using row_number function in all records fetched (with -t without -t)

enter image description here

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Gurupreet Singh Bhatia