row « SQL « Java Database Q&A





1. how do I make a select which always returns zero rows    stackoverflow.com

I want to determine if a column exists in a table for any jdbc driver. In order to know the columns in a table, I have to make a query to the ...

2. SQL for retrieving data from all the rows for a particular id in the list and then call a function?    stackoverflow.com

Any performance issues in the code below: Goal: I want retrieve data from all the rows for a particular id in the list and then call a function a = list of 2000 ...

3. why it checks just the last row of sql?    stackoverflow.com

I use this method in my database class which checks the password and yahooId ,if they were correct it allows the user to go to the next frame .I have added ...

4. sql cleanup function. rows doesnt get really deleted    stackoverflow.com

i am using java sqlite (org.sqlite.JDBC) with this i am adding a new row of data to the table, one field is supposed to take up a big amount of base64 ...

5. what is the harm of using executeQuery instead of executeUpdate for deleting rows    stackoverflow.com

In my code I am using

String query= "delete all from myTable";
stmt.executeQuery(query);
Ideally for DML executeUpdate should be used instead. However, executeQuery too works well. So, was curious to know what could ...

6. sql to add values across rows and down columns    stackoverflow.com

I'm porting an excel "database" to a real database application and the customer wants to see familiar spreadsheet views showing data added across rows and summed down columns. Is this ...

7. select data from last 2 rows sql    stackoverflow.com

Im using an odbc-jdbc bridge in my project and I need select 2 pieces of data from the database and save the data to 2 variables on the java side of ...

8. Retrieving a subset of rows with SQL    coderanch.com

Hi, I have an SQL question. I hope this is the appropriate forum for it. I would like to know if there is any way to retrieve a set of rows from a table without using an identifying column ie. primary key. I want to be able to write a JDBC application where I can plug a table name into a ...

9. SQL statment to Delete a row    coderanch.com

DELETE FROM MYTABLE WHERE FIELD = 'SOMEVALUE' The WHERE clause can be as complex as you want. Just be careful; if your WHERE clause is incorrect, you may delete records you did not intend to delete. In fact, if you leave the WHERE clause off completely DELETE will delete all the rows in the table. Joe





10. select a range of rows by SQL    coderanch.com

11. Getting totals of rows in SQL    coderanch.com

Nitin, I havrn't worked with sql server but i remeber there is a function rollup which will give you desired result try this query select emp_dept,sum(sal)"salary",sum(bonus)"bonus" from employee group by emp_dept order by emp_dept WITH ROLLUP This should give you an additional row having desired result. thanks [ February 04, 2005: Message edited by: Shailesh Chandra ]

12. SQL Select to concat rows    coderanch.com

13. SQL puzzle about removing duplicate rows    coderanch.com

I currently find myself in a situation where one of my database tables has ended up with a *lot* of duplicate rows - over 14 million where there should be more like a few thousand . I want to add a compound key constraint to the table to prevent this happening in future, but the database won't let me because of ...

15. SQL: howto retrieve only the first row?    coderanch.com

16. java.sql.SQLException: Result set is in an invalid state. May be before the first row or after the    coderanch.com

I am using JNDI Datasource (running in weblogic8.1) to connect to database. I have inserted 2 rows in the table. Below is the code. I am able to get the resultset. But, I get "java.sql.SQLException: Result set is in an invalid state. May be before the first row or after the last row". I can understand this is because of not ...





17. sql for select intermediate rows    coderanch.com

18. deleting more than one rows sql    coderanch.com

hi, this is nearly sql question, i'm having a table X containing 12 columns and 10 rows, in this combination of first six columns is primary key. i have 5 rows in an array which exactly matches with the rows of table X. now i want to delete the rows which are not matched with that 5 rows. without deleting all ...

19. Maximum size of a row in sql    coderanch.com

I recall in Oracle knowing the table data limit is practical, in part because if you have 2-3 large columns (free text entry such as VARCHAR(2000)) you'll hit it fast. Oracle "encourages" clobs at point since they don't get stored in the table directly. I've never thought much about the row limit per query though, since there would probably be bandwidth ...

20. SQL> no rows selected    coderanch.com

21. java.sql.SQLException: [SQL0913] Row or object PAYMENT in PRDEBS type *FILE in use    dbforums.com

Can anyone assist re the cause of this error?? 08:54:26 Category 2: Invalid AuthoriseRS data returned, Error: java.sql.SQLException: [SQL0913] Row or object PAYMENT in PRDEBS type *FILE in use. Cause . . . . . : The requested object PAYMENT in PRDEBS type *FILE is either in use by another application process <<< truncated >>> 21-Aug-2003 08:54:26 Category 2: Database access ...

22. SQL row filtering    dbforums.com

Hello, I've been working on this problem in vain for several days now. I essentially am looking for one row per hour where that row is the youngest row of that hour. So if there are say three rows labeled (17:00, 17:41, 17:43) I only want 17:43's row to show for the 17th hour. Essentially I want to see what I ...

23. SQL problem - not going to next row? I think    forums.oracle.com