I'm doing a query , however I'm learning now. Can you improve the performance of this query?
select a.COD_EMPRESA, b.Dat_pagamento
from SAS_EMPRESA a
full outer join SAS_ITEM_PAGO b on (a.COD_PREF_EMPRESA || a.COD_EMPRESA = b.COD_PREF_EMPRESA...
I am making a query sql on ruby-on-rails on PostgreSQL where I check if user input is between hora_entrada and hora_entrada + (hora_entrada + limite_banco_horas) and same for hora_fim , in a certain...
I'm trying to set up a generator system of Vouchers/Tickets
I have a table in SQL with the name Vouchers with multiple users and their respective passwords.
I call each cell the variable $serial_voucher and $senha_vou...
I have a query that searches sales for a period:
SELECT cxpdvend.filial,
cxpdvend.dtpedido,
cxpdvend.pedvenda,
ciendere.nro_endere,
cipessoa.nomepessoa,
ciendere.celular,
cxpdvend.codagente,...
I have a query in the header of the page that returns the title, the meta name="description" and the meta name="keywords" that works very well. However, applying this same query structure to the body of the page returns no value. I already teste...
I'm trying to use wildcard character as query criteria in my query, but the result is returned empty.
include_once ("../ inc / connection.php");
$lj = "4";
$linha = isset($_GET['ans'])?$_GET['ans']:"";
$data = date("d-m-Y");
$partes...
Running the update statement below is experiencing the following error. What can it be?
Msg 116, Level 16, State 1, Line 3
Only one expression can be specified in the select list when the subquery is not entered with EXISTS
UPDATE Est...
Hello everyone, I'm having a problem querying the firebase database.
The bank is this:
I'mtryingtodoasearchforalltherestaurantsthathavethenameIguatemi,untilthenaccordingtomydebug,I'mgettingtodoitgood.Theproblemisthatwhenthedataistaken,iti...
Would anyone know how to tell me how this MySQL query would look like in SQL Server and Oracle?
SELECT
COUNT(*) AS TOTAL,
SUM(EVENTO = 7 AND RESULTADO = 0) AS QTD_RX_OK,
SUM(EVENTO = 7 AND RESULTADO <> 0) AS QTD_RX_ERR,
SUM(...
Good afternoon!
Well, I have a great mission that is as follows. I have a script that I set up below that I need it to be executed only on the 1st of each month, respecting the two conditions that I put in the IF clause. I tried via trigger a...