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.