File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
To extract column elements from a particular position onwards "MYSQL"
Joined: Oct 08, 2006
Dec 16, 2006 13:25:00
Hi to everyone,
I want to extract column elements from a particular position .
here i want to have values from 13 onwards.then what shall i do
Joined: Oct 14, 2005
Dec 16, 2006 14:28:00
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:
Select * from whateverthetableiscalled where sn >= 13
Joined: Dec 08, 2006
Dec 23, 2006 11:57:00
$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>
I agree. Here's the link:
subject: To extract column elements from a particular position onwards "MYSQL"
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...
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015