I have a query:
select qid,ansid,ans from table1 where askerid='something'
This query can retrieve many rows. But I want to display only 50 rows at a time and then if the user clicks on more
, the next 50 rows should be retrieved. I have thought of a query like this :
select qid,ansid,ans
from table1
where askerid='something'
limit 100
minus
select qid,ansid,ans
from table1
where askerid='something'
limit 50
I want to know if this is a good query performance-wise and alternate queries that perform better than the above one.