[SOLVED] Getting the 3rd value in a MySQL table column.

[ridiculous]

Can't find any documentation on this, and the only workarounds I've seen are ridiculous-like me.

 

 

This code doesn't work for MySQL, because MySQL is flitty.

 

 

 

 

 

 

 

 

 

mysql_query ("

				Select MAX(price) as ask2, sum(quantity) as bid_1
					from 85068ramiros13 
						where action ='sell' 
							AND price 
						NOT IN(SELECT MAX(price) FROM 85068ramiros13 ORDER BY PRICE desc limit 2 ) 
					GROUP BY PRICE 

					desc limit 2
				") 

 

 

 

 

Sing with me, from Foreigner: "Urgent, emergency. Urgent, urgent, urgent...emergency.

"

[ridiculous]

This will get you the second value in a column, but I can't figure out how to augment it to retrieve the 3rd.

 

mysql_query ("

			Select MAX(price) as ask2, sum(quantity) as bid_1
					from table 
						where action ='sell' 
							AND price 
						NOT IN(SELECT MAX(price) FROM table ORDER BY PRICE) 
					GROUP BY PRICE 

					desc limit 2
				") 

[ridiculous]

Urgent...emergency

 

 

 

[ridiculous]

Well, if you want something done you have to do it yourself.

 

 

GROUP BY PRICE

ORDER BY PRICE ASC LIMIT 1,1

 

 

That's it.

 

Group and order, then limit. So crzy.