SQL query not working well

Posted on 16th Feb 2014 07:03 pm by admin

I made a small table with 5 rows and want to make them an sql consult using rownum

so I'm running
select * from mytable where rownum = 1;

and it gives me the first row but if I change the 1 for a 2 or 3 or 4 or 5 it's says that theres nothing :S


but if i change for between 1 and 5 it gave me the 4 rows :S :S


No comments posted yet

Your Answer:

Login to answer
120 Like 6 Dislike
Previous forums Next forums
Other forums

WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - P

I have a parse error in this query help..
Code: $query1="INSERT INTO `rating` (`item_name`, `rating`, `ip_address`, `date_rated`) VALUES

present value of sequence?

Please help me to find out the present value of sequence?


Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th

Error with Font and imagettfbbox
I keep getting an error that says "Warning: imagettfbbox() [function.imagettfbbox]: Could not f

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS

Play Free Quiz and Win Cash