Questions tagged as 'sql'

Tagged questions
1
answer

TOTAL row with SUM of columns using PIVOT

Is it possible to make one row of TOTALS per column? The explanation of the totals per line was fantastic and it turned out beautiful in my project. Thank you. My code: SELECT ano AS Ano, CCUSTOS AS [Centro custos], coalesce(...
asked by 11.06.2018 / 13:15
0
answers

Insert into the database a value of type date [duplicate]

How can I insert the value of a date, for example 2018-06-12, into the database from a java application? I have the application made in javafxml and when I run the application and I enter the date and the rest of the values it gives me this er...
asked by 11.06.2018 / 01:52
0
answers

Insert into the database a value of type date [duplicate]

How can I insert the value of a date, for example 2018-06-12, into the database from a java application? I have the application made in javafxml and when I run the application and I enter the date and the rest of the values it gives me this er...
asked by 11.06.2018 / 01:52
1
answer

Result of select feeding 2 other selects

I have select 1 SELECT DISTINCT SD2.D2_DOC AS NOTA, CONCAT(RTRIM(SD2.D2_CLIENTE), ' - ', SA1.A1_NOME) AS CLIENTE, SD2.D2_COD AS CODPRODUTO, QEK_REVI AS REVISÃO, SD2.D2_LOTECTL AS LOTE, SB1...
asked by 14.06.2018 / 19:57
1
answer

Group values in a PHP Mysql query

I am pulling BD values into a table with the query results, this search is by date, it works perfectly if I fetch for a single day, however I would like when to fetch for two or more days (ex 07/06 / 2018 to 08/06/2018), it would bring the group...
asked by 08.06.2018 / 15:44
4
answers

Select with columns reporting incorrect data

Hello I have one more problem regarding a search in the database. I want to make a SELECT that searches for information such as company code, social reason, year and values (summed). At first, the search for information without the company na...
asked by 08.06.2018 / 15:38
0
answers

Is giving error when I try to insert into my sqlite + java database

package Contas; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Scanner; import javax.swing.JOptionPane; import BancoConexao.Banco; public class ContaCorrente extends Conta{ public ContaCorrente(int NumCo...
asked by 08.06.2018 / 15:04
0
answers

___ ___ Do erkimt a SELECT on two of the same server with BANKS INTO OUTFILE output on another server ______ qstntxt ___

I need to make a query on two databases and generate a csv file, but I do not have write access to the mysql server, how does the output file of INTO OUTFILE write to another server?

    
___

I need to make a query on two databases and generate a csv file, but I do not have write access to the mysql server, how does the output file of INTO OUTFILE write to another server?     
asked by 08.06.2018 / 00:49
0
answers

Oracle - Error inserting a row - index marked FAILED

Good morning! When trying to insert a line in the database, it gives the error:    The domain index is marked LOADING / FAILED / UNUSABLE This index marked as failure has the name: "ROLO_IDX" When trying to rebuild the other error:...
asked by 08.06.2018 / 15:16
1
answer

ERROR NO PHP: Fatal error: Call to undefined function sqlsrv_query ()

My login validation is giving this error: Fatal error: Call to undefined function sqlsrv_query() every time I try to login to the site I created. I made the connection to the db SQL SERVER: <?php class Conexao { private stati...
asked by 07.06.2018 / 13:37