mrherman Posted August 14, 2011 Share Posted August 14, 2011 Hi -- I'd like to ask about the SQL statement below, which is something that I didn't know about: the second SELECT, after the FROM phrase. My question is, what is this called? Is it a NESTED SELECT, a SUB-SELECT, an EMBEDED SELECT, or what? I want to read more on this type of statement, but don't know how to classify it. Thanks! SELECT t.* FROM table1 t, ( SELECT id FROM table1 ORDER BY id DESC LIMIT 5,1 ) as x WHERE t.id <= x.id ORDER BY RAND() LIMIT 3 Link to comment https://forums.phpfreaks.com/topic/244799-what-is-this-type-of-select-statement-called/ Share on other sites More sharing options...
MasterACE14 Posted August 14, 2011 Share Posted August 14, 2011 Subquery. Link to comment https://forums.phpfreaks.com/topic/244799-what-is-this-type-of-select-statement-called/#findComment-1257469 Share on other sites More sharing options...
mrherman Posted August 15, 2011 Author Share Posted August 15, 2011 Well, that was simple enough. I thought subqueries were always in the WHERE clause. But I looked it up and you are right. Very helpful. Thanks! Link to comment https://forums.phpfreaks.com/topic/244799-what-is-this-type-of-select-statement-called/#findComment-1257478 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.