MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1(id int, name varchar(10), time1 time)
insert into t1(name,time1)values('sandeep','10:00:00'),('sandeep','10:10:00'),('sandeep','10:10:00'),('sandeep','10:20:00'),('sandeep','11:00:00'),('sandeep','11:00:00'),('sandeep','11:00:00');
select * from t1 where time1=(select TOP 1 time1 from t1  order by time1 desc  )
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 time1 from t1  order by time1 desc  )' at line 1

select * from t1   where time1  = ( select max(time1) from t1   )


id
name
time1


null
sandeep
11:00:00

null
sandeep
11:00:00

null
sandeep
11:00:00


select * from t1   where time1  =(select time1 from t1 order by time1 limit 0,1)


id
name
time1


null
sandeep
10:00:00

id	name	time1
null	sandeep	11:00:00
null	sandeep	11:00:00
null	sandeep	11:00:00