Mysql queries all rows whose maximum time is one of the three conditions.

The table structure of all rows whose Mysql queries meet the following conditions: SELECT & nbsp; * & nbsp; FROM & nbsp; table & nbsp; WHERE & nbsp; dtime & nbsp; (select & nbsp; max (dtime) & nbsp; from & nbsp; final) & nbsp; and & nbsp; custome Mysql queries all rows that meet three conditions, one of which is the maximum time
The table structure is as follows:


Query statement:
SELECT * FROM table WHERE dtime = (select max (dtime) from final) and customer = 'test' AND nbname = 'Dell XPS 13'
No query is available.

However, after the dtime = (...) section in where is removed, the result is displayed.
After this section is added, no results will be matched.
How to modify it.
------ Solution ----------------------
Let's see what the select max (dtime) from final gets?