2
Reply

Compare 2 sets of columns in same table

Santosh Sasupalli

Santosh Sasupalli

Oct 19 2017 3:08 AM
163
hi,
 i have a table like that
 
id    value                               id        value
-------------                             ------------------
1        2                                1             2
2        4              (or)            2            4
3        3                               3               6
  
 
now i want a query. that  id is descendi order the values mustbe in descending order then only return true. else return false. i mean 1st tbl return false 2nd tbl return true
pls help me
 
 

Answers (2)