hi,
In my table, studentId has multiple values..e.g
studentId
['dfd','34343','fc041a4b']
['df','34343']

select * from StudentResultData where studentId != 'fc041a4b'

I think this query is returning only the first Row , but how can it returns me both the rows.. pls help. Is there a way ?

hi,
While
select * from StudentResultData where studentId = 'fc041a4b'
this works good, and only gives the first row..

now just check out the "every" keyword. the examle query would be:

select * from StudentResultData where every(studentId) != 'fc041a4b'