I have a data table as follows:
Code: Select all
messageID | message
---------------------------
1 "hi"
2 "hello"
3 "apple"
4 "orange"
5 "banana"
6 "grape"
I want to select 'hello, apple, orange, banana' only.
How do I write the query for this? I have a hold of the first messageID of the output, which is 2 (hello). How can I use this in my query?
Please help.