I'm trying some alternatives to show only the records of the last 30 days, but I could not make it work, the query I have looks like this:
SELECT comunidade.descricao AS nomeunidade
,comcargo.descricao AS nomecargo
,comcolaborador....
I have the following function that treats a time that comes from the bank:
SELECT f.chapa AS chapa,
f.nome AS nome,
f.secao AS cod_secao,
f.nsecao AS desc_secao,
c.codigo AS cod_funcao,
c.nome AS desc_funcao,...
I'm developing a very complex system, where in some cases I need to select only a few fields, a friend who has more experience in the area gave me some tips, but he did not explain why.
I have the following query that searches all users in r...
I have a problem submitting Query.
I have the alvaraValidade field that only receives Date fields.
When I do not put anything in this field, the date field is saved as 0000-00-00 .
$sql = "Select * From tb_trabalhador wh...
My problem is to use the quotation marks in a query within an R function.
I have to call a list of
select * from probes."probes_90_2018-05"
For this I do:
coelho<-dbConnect("PostgreSQL", fnord)
dbGetQuery(coelho,"select *
from probe...
I have tried unsuccessfully to get a result.
I have the table with the following Login and Logout information:
|Group |User |EventDate |Event |Camp
------------------------
|Evolution |1012 |2014-07-07 10...
I need to make a query where the result is the medals (gold, silver, bronze and total (sum of 3)) obtained by each country in all editions of the Olympic Games. So far so good, the query below already does this.
The problem is that the medals...
Good morning,
I need to know a% change from last month's job records to job records made this month. For this I need to compare with the current day, for example.
If today was 10/15/2015
I need to count how many tasks were opened between 0...
So folks, I'm not able to solve this problem of a query inside a foreach loop does not execute. First of all I thought it was something wrong with pdo-> beginTransaction so I commented this part and left pure code only.
<?php
if (is...