Related to excel database and sql database RRS feed

  • Question

  • User-112308782 posted

    how to implement this query SELECT ROW_NUMBER() OVER (ORDER BY column) AS seerial number , * from table name on excel file actually this query on sql server

    I need it in excel data base to get records with serial numbers in grid view

    Thursday, November 25, 2010 1:44 AM


  • User-254911852 posted

     Step1: Open Current Excel Sheet

     Step2: Select the column and Right Click -> Add new column

    Step3 : Give column Same as SNo

    Step4 :Enter first value as 1

    Step5: Drag the column values down u will get serial number

    All the very best

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 25, 2010 4:53 AM