Questions tagged as 'query'

Tagged questions
2
answers

Concatenate values from the same column

How do I concatenate the values of the same table Table example | Usuario | Formulario | Acao | Permitir | | Admin | Contrato | Imprimir | 1 | | Admin | Contrato | Consultar | 1 | | Ad...
asked by 28.06.2016 / 19:34
1
answer

SQL / ORACLE Filter active records in month

I have a table that writes my records where one column writes the data_inicial and another column the data_final . I need to generate a report where the user searches all the records that were between the period of eg 03/03/2017...
asked by 10.04.2017 / 19:41
1
answer

SQL Server 2012, error executing query

Good afternoon, people When you run the query below: select PRO_Descricao, PED_Numero from pedido p, item i, produto pr where p.PED_Numero = i.PED_Numero and i.PRO_Codigo = pr.PRO_Codigo and PRO_Descricao >= 'SA' and pro_descricao < '...
asked by 29.10.2015 / 21:22
4
answers

PostgreSQL - Remove tuple referenced by another table

I have a problem that I did not find anything on Google (maybe I did not know how to ask him) Imagine the following: I have 11 tables, one call tbl_pai and 10 other calls tbl_filha1 , tbl_filha2 , tbl_fila / em>. / li>...
asked by 27.01.2016 / 14:05
1
answer

How to return more than one column from the same table?

With this SQL I can in my database select and group products by variations that would in this case be different attributes for the same product. So, when generating the view of the product, I have a dropdown in the product with all the attrib...
asked by 26.11.2014 / 17:22
1
answer

How to use "Not Exists" in LINQ?

I'm trying to translate the query below into LINQ, but without success, can anyone help me? SELECT * FROM PESSOAL A WHERE NOT EXISTS ( SELECT Chapa FROM PRODUCAO B WHERE B.Chapa = A.Chapa AND B.Data='2014-09-02') AND A.Codsubord='CB...
asked by 10.09.2014 / 16:22
4
answers

Consume values from a webservice

I do not have any knowledge of the use of webservice , and I need to use one now to consume data from a database (Usually I would fetch the data direct from the database, but in this case the admin did not authorize, the only way was to ma...
asked by 22.07.2014 / 11:28
1
answer

Search by date in mysql

Good evening, I have records in my table about phases of the moon 4089 Lua nova 1983-05-12 19:26:41 4090 Primeiro Trimestre 1983-05-19 14:18:16 4091 Lua cheia 1983-05-26 18:48:29 4092 Quarto Minguante...
asked by 24.10.2014 / 02:15
1
answer

Update on two SQL Server tables [duplicate]

How do I perform an update at the same time on two different tables? I have a table named Tarefa and another called VinculoReferencia , both have the field Taridinclusao where is this field that needs to be updated at th...
asked by 02.10.2017 / 22:56
2
answers

SQLSERVER compare two groups of results

I need to query the sql server where I have to "connect" inventory to the companies. The stock has 'n' products attached to it, and these products have 1 category attached to it. The company also has 'n' categories attached to it. I nee...
asked by 03.11.2017 / 20:21