Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2014
    Posts
    2

    Unanswered: SQL to find Duplicate Column Values For same row.

    I have a table With Column SNO, col_1, col_2,.....,Col_30.

    I need to Query the Table to find if the Values in col_1, col_2,.....,Col_30 is duplicated for a specific Row

    EX. SNO | Col_1|Col_2|......|Col_30
    1 | 2 | 4 |......| 5
    2 | 1 | 4 |......| 1
    3 | 5 | 7 |......| 7


    Then the Query Should Fetch SNO 2,3

    I am Querying in to Excel File to Fetch Record Using ODBC Connectivity.
    Last edited by AbhijitDas; 07-14-14 at 10:44. Reason: Update

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What Database Management System are you using?
    SQL Server, MySQL, DB2, Oracle, etc?
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2014
    Posts
    2
    I am trying to Query in to Excel with ODBC Connectivity

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •