Jump to content

sql sub query


samona

Recommended Posts

Hi,

 

I have the following query in my php code

 

$query = 'Select * From Table_Name as t WHERE t.t_ID = 
(Select Max(t_ID) From Table_Name Where Type = t.Type and length = t.length) 
ORDER BY t.Type, t.length';

 

It takes about 51 seconds to return the results in this query in a table with only 3,000 records.

 

I was wondering if anyone knows a way to make this query more efficient?

Link to comment
https://forums.phpfreaks.com/topic/208207-sql-sub-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.