SQL masters: - GoFuckYourself.com

Zester · 02-09-2006, 04:56 AM

What is wrong with this Sub Query:

Code:

SELECT date 
FROM  `records` 
WHERE  STATUS  =  'published' 
AND date = ( select max(date) FROM `records` )
LIMIT = 25;

it's suppose to spit out the date of the latest 25 articles in 'published' status and nothing more.

everestcash · 02-09-2006, 06:04 AM

i was thinking, is there a way to rewrite that query using 'order by id' or 'date' instead, without using a sub query. That'll be a simpler approach.

like

select from `records` where status = 'published' order by id desc limit 0, 25;

ddfGandalf · 02-09-2006, 06:09 AM

select date from records where status='published' order by date desc LIMIT 25;

woj · 02-09-2006, 06:13 AM

Quote:

Originally Posted by everestcash

select from `records` where status = 'published' order by id desc limit 0, 25;

Pryda · 02-09-2006, 06:15 AM

Quote:

Originally Posted by Zester

What is wrong with this Sub Query:

Code:

SELECT date 
FROM  `records` 
WHERE  STATUS  =  'published' 
AND date = ( select max(date) FROM `records` )
LIMIT = 25;

it's suppose to spit out the date of the latest 25 articles in 'published' status and nothing more.

Your query wants up to 25 record dates for articles published on the same date as the most recent record (published or not).

sickbeatz · 02-09-2006, 06:20 AM

SELECT date
FROM `records`
WHERE STATUS = 'published' ORDER BY date DESC LIMIT 25;

02-09-2006, 04:56 AM	#1
Zester Confirmed User Industry Role: Join Date: Jul 2003 Posts: 5,344	SQL masters: What is wrong with this Sub Query: Code: SELECT date FROM `records` WHERE STATUS = 'published' AND date = ( select max(date) FROM `records` ) LIMIT = 25; it's suppose to spit out the date of the latest 25 articles in 'published' status and nothing more. __________________ * Mainstream ? $65 per sale * new male contraception Last edited by Zester; 02-09-2006 at 04:58 AM..

02-09-2006, 06:04 AM	#2
everestcash Confirmed User Join Date: Apr 2002 Posts: 2,194	i was thinking, is there a way to rewrite that query using 'order by id' or 'date' instead, without using a sub query. That'll be a simpler approach. like select from `records` where status = 'published' order by id desc limit 0, 25; __________________ Got solo girls/teen traffic? Promote our exclusive solo girl sites and boost your income!

02-09-2006, 06:09 AM	#3
ddfGandalf Confirmed User Join Date: Feb 2005 Location: Budapest, Hungary Posts: 534	select date from records where status='published' order by date desc LIMIT 25; __________________

02-09-2006, 06:20 AM	#6
sickbeatz The Hustler Join Date: Feb 2005 Posts: 4,993	SELECT date FROM `records` WHERE STATUS = 'published' ORDER BY date DESC LIMIT 25; __________________ GalleryFeeder.com