Forums Register Login

To extract column elements from a particular position onwards "MYSQL"

+Pie Number of slices to send: Send
Hi to everyone,
I want to extract column elements from a particular position .

like this

MYSQL table:
Sn Balance
12 550
13 450
14 360
15 800
16 456
here i want to have values from 13 onwards.then what shall i do
+Pie Number of slices to send: Send
You don't say whether the "sn" column is ordered in any way, although it is ordered in your example. And it's impossible to guess whether it might be just from its name.

Assuming that it is ordered:
+Pie Number of slices to send: Send
$sql = "select * from table where sn >= 13";

Will get your answer...
pie. tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 802 times.
Similar Threads
extract particular elements from arraylist
Retrieve binary file from database and send to user via web browser
writing to a file at a particular place
Retrieve MySQL table column names
StreamTokenizer problem again...
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 02:16:26.