This discussion is archived
2 Replies Latest reply: Jun 20, 2013 3: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 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points