MySQL Forums
Forum List  »  Newbie

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
December 05, 2012 07:51PM
December 05, 2012 08:17PM
December 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.