MySQL Forums :: Newbie :: SubQuery and result


Advanced Search

SubQuery and result
Posted by: KiJung Poong ()
Date: December 05, 2012 07:51PM

I have a query that I think its result is strange.
If I execute subquery, I can get the result.
but if I execute whole query, I get nothing.


SELECT @RNUM:=@RNUM+1, z.* FROM (

SUB QUERY

} z


Is there any setting value that I can change?

Options: ReplyQuote


Subject Written By Posted
SubQuery and result KiJung Poong 12/05/2012 07:51PM
Re: SubQuery and result Peter Brawley 12/05/2012 08:17PM
Re: SubQuery and result Rick James 12/08/2012 12:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.