2 Replies Latest reply: Jun 20, 2013 5:41 PM by dariyoosh RSS

    How to check the count of one column value is less than the other column value in a table with one unique column

    1004386

      Hi,

       

      Please let me know how can we query the same table and get the records which are less than other column.

       

       

      id   item_id   item_type

      3     1           r1

      2     4          r2

      1     5          r3

      6     5          r4

       

      I need to get all the rows in which item_id<id

      o/p

       

      id   item_id   item_type

      3     1           r1

      6     5          r4