sql - what is the alternative of giving a nested query in where clause returning more than 1 values in mysql -

what alternative of giving nested query in clause returning more 1 values in mysql?

the query iam using single value

select *  libertymutual.echi_filtered  anslogid = 2984012 , calltime not null  order calltime limit 2,1;

and need multiple anslogids other query

select anslogid  libertymutual.echi_filtered  group anslogid

which should return 3rd call every agent when sorted calltime.

any appreciated.

Today