I have sql query which is not run due to 10k value i passed in operator

Question

Select * from ABC
Where df=1
And cf not in ( select mno from ggg where df=1)

Answer 1

May be use LIMIT to display the desired number of entries.

Answer 2

Please add error description in your question Description. It may help others to analyse and suggest appropriately 👍

(Edit)
Include your tables structure so others can understand how data is organised in your database.