Questions tagged as 'sql'

Tagged questions
1
answer

Select like (2 different parameters)

I have a table with several cars, I need to pick only the ones I need. Example: goal fox parati kombi voyage I just want to get a goal and a kombi. I'm using the following command to get where I have the GOL value in my table ......
asked by 05.08.2015 / 19:39
2
answers

Select only the first record of a column

The select below returns something like 005-A Produto A 21/AGOSTO 005-A Produto A 20/AGOSTO 005-A Produto A 21/MAIO 005-B Produto B 21/AGOSTO and I would like one record per product equal to the following 005-A Produto A 21/AGOSTO 005-B P...
asked by 21.08.2015 / 22:40
1
answer

My application does not change data in the database

I'm developing a software for a video store with MVC. There are two problems: not changing people's attributes and displaying the following error:    java.sql.SQLException: Column 'code' not found '. This error is saying that there i...
asked by 27.10.2015 / 18:58
3
answers

SQL SELECT return

I need to do a select comparing whether user login is already existent or not. But I do not want it to return me values from the table, just a symbolic value to check for existence (true or false). The comparison code is the basics: SELECT * F...
asked by 24.07.2014 / 15:55
1
answer

How to Pass Values to Procedure Parameters - PL / SQL

I asked the management company of our system to change the code of some of the neighborhoods of the system, it made that change, now I need to change the code of other districts that are in the system, I know that change is delicate and that the...
asked by 09.04.2014 / 17:19
2
answers

SQL does not return all results it should return

I have the following tables in my bank: I want to select all the products of a certain site (this site marked by the user through a checkbox ) with the following sql : SELECT Eletrodomestico FROM Produtos WHERE URL LIKE (SELECT...
asked by 04.05.2015 / 18:58
1
answer

Return amount of dependents per employee

I need to select the Plaque, Employee Name, and Dependent Amount for each Employee, but the result of that query is showing the number of dependents for the first Employee only, / p> Note: If you remove the WHERE clause, the query shows...
asked by 03.11.2018 / 20:36
2
answers

Display date correctly in a JTable

I'm not able to display the sql database date type Date in JTable, the date appears like this: Iusethefollowingmethodtocallthetabledata:publicArrayList<Alunos>read(){PreparedStatementstmt=null;ResultSetrs=null;ArrayList<Aluno...
asked by 27.11.2018 / 20:42
2
answers

CheckBox concatenating string several times

Iwantedtoclickonthecheckboxandthenontheregister,savethealreadypredefinedvalueandservicename(description)inthedatabase.However,thedescriptionisaproblemforme,becausewhentheusermarksandunchecksthecheckboxseveraltimes,itendsupconcatenatingmorethanex...
asked by 28.02.2015 / 03:51
1
answer

Error: More than one value was returned by a subquery

Could you help me identify the error:    SELECT Failed. 3669: More than one value was returned by a subquery. SELECT (SELECT ID_FUNC FROM P_ISIDB.TB_DIM_FUNCIONARIO INNER JOIN P_ISIDB.TB_STG_VNDA ON P_ISIDB.TB_STG_VNDA.COD_FUNC = P_IS...
asked by 22.10.2018 / 19:40