SQL query not working well


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

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

so I'm running
Did you know?Explore Trending and Topic pages for more stories like this.
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

why?????????????????????

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

why???????????????????
No comments posted yet

Your Answer:

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

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows

SQL>

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

rand() function
just a general question guys a girls, is the rand() function 100% random or is it based on time?

Quick Syntax Question
Hi folks,

I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b

Validating time
Hi Guys

what do you think of the following approach to validate a 24hour time:

http://

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

Secure pages Sessions vs. Cookies & session_destroy() help
Im new here and new to PHP, I hope you can help me with some questions.

Im writing my web ap

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

Upload file!
Ok i have a form..
Code: <form name="form1" method="post" action=&quo

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

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