CODEWITHSUNDEEP
mysqlsqlfiddle
cocoo84hh
cocoo84hh

Reputation: 311

How to get execution time on DB Fiddle?

Hi I have query built on DB Fiddle, MySql 8.0 and I want to see the execution time. I am not sure how to do this on this tool. Can someone help for the query below?

select a.e_id from 
(
select *,
DENSE_RANK() OVER(PARTITION by e_id ORDER BY start_date desc)rk,
count(*) over(partition by e_id) as company_ct
from employment
order by e_id asc,start_date desc
)a
where a.rk=1 and a.company_ct>1;

Upvotes: 0

Views: 343

Answers (1)

Brits
Brits

Reputation: 18245

As @Nick said it's displayed within the db-fiddle interface; for example the screenshot below shows an execution time of 1ms. Not sure why you would need to add any additional code?

db-fiddle example

Upvotes: 0

Related Questions