Select Row number in postgres

  • 1 Answer(s)

    This is Select Row number function

    SELECT tab.*,
    row_number() OVER () as rnum
    FROM tab;

    Refer this document

    This matched answer for your question

    Answered on January 9, 2019.
    Add Comment

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.