Particular SQL takes more than 5 hours to run in SQL developer

[Dorothy Timina]

Hi Team,



I am trying to run the below query in SQL developer , its taking many hours to run this query,i don't exactly understand the reason for a long execution time, please assist.

Data Base: MySQL

Total Number of records in table: 100000

Application used to Run the query : SQL Developer

RequestID in the below query is a Primary Key of the table,

select *

from WalletCSV.I_requests as requests

where exists (

select 'X'

from WalletCSV.I_requests as E

where requests.requestID = E.requestID

group by E.requestID

having count(*) > 1

)



Regards,

Gowtham Raja S

[phone]