1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

Finding Duplicate Entries in a table

Discussion in 'SQL - Questions and Answers' started by novice82, Aug 14, 2009.

  1. novice82 New Member

    I have a table with the following fields in Oracle 10g.

    TABLE_1

    account_no | tracking_id | trans_amount

    Each account_no can have multiple tracking Id's.

    How do i query out the duplicate entries of account_no where tracking lies between 1 and 1000, having the same / different trans_amount ?

    Many thanks in advance for your help,

    novice.
    novice82, Aug 14, 2009
    #1

Share This Page