| Author |
To extract column elements from a particular position onwards "MYSQL"
|
sandeep ep
Greenhorn
Joined: Oct 08, 2006
Posts: 4
|
|
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
|
 |
Paul Clapham
Bartender
Joined: Oct 14, 2005
Posts: 16483
|
|
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:
|
 |
Neerav Narielwala
Ranch Hand
Joined: Dec 08, 2006
Posts: 106
|
|
$sql = "select * from table where sn >= 13"; Will get your answer...
|
<a href="http://www.java-tips.org/java-tutorials/tutorials/" target="_blank" rel="nofollow">Java Tutorials</a> | <a href="http://www.planet-java.org" target="_blank" rel="nofollow">Java Weblog</a> | <a href="http://computer-engineering.science-tips.org" target="_blank" rel="nofollow">Computing Articles</a>
|
 |
 |
|
|
subject: To extract column elements from a particular position onwards "MYSQL"
|
|
|