Questions tagged as 'query'

Tagged questions
1
answer

Query to get errors and hits from a student

I would like a query to get errors and hits from a particular student from the following table below:     
asked by 15.05.2018 / 22:15
0
answers

Sqlite recursive query

I'm starting with sqlite and would like help with a recursive query. I have 3 tables (generic example): CREATE TABLE IF NOT EXISTS tab_componente ( id_comp TEXT NOT NULL PRIMARY KEY, desc_comp TEXT , custo_comp INTEG...
asked by 28.04.2018 / 15:52
1
answer

Join Names in a row

Good afternoon, we use SQL SERVER 2008 as the official database server and have the following query: SELECT P.NOME AS [PROFESSOR], STIPOCURSO.NOME AS [NÍVEL DE ENSINO], SPL.CODPERLET AS [ANO], ST...
asked by 05.04.2018 / 19:45
1
answer

Linq command to bring a decimal query C #

I'm having trouble understanding how to bring a query from the textbox of a column where the field is decimal? if (txtNomePesquisar.Text.Equals("")) { MessageBox.Show("O que você procura? "); } else { var clientes = cc...
asked by 26.10.2017 / 00:59
1
answer

Query with MAX (DATE)

I'm trying to generate the query below as follows. Cliente Tarefa Data da Ultima Providencia Teste 16555 04-07-2017 However, it is generating in a duplicate way, that is, I want to get the last date of the last provisio...
asked by 18.09.2017 / 21:22
1
answer

SQL to count records that have a repeating value field

Personal I need a Query that does a count of values that I have in the bank On my system, I have a multiselect that can select more than one option. I wanted your help, I never moved with a query, I need a Query that tells me how many numb...
asked by 25.07.2017 / 17:24
0
answers

I wanted to do a query that would return the following data in mongodb

COLECTION GAMES { id : 10, casa : "Sport", visitante : "Chapecoense", horario : "2017-07-20 11:00:00" } COLLECTION BETTER { nome : "wedson", apostas : [ { idjogo : 10, opcao : 1, valores : 1 } ] } I w...
asked by 16.07.2017 / 11:26
2
answers

Use an if with two selects

I am doing a query, in which the second query can give "NULL" or a value (if there is data). SELECT *, (SELECT tb1.image FROM ce_users_images tb1 WHERE tb1.iduser = users.iduser LIMIT 1) AS tmp1 FROM ce_users users WHERE users.id_us...
asked by 26.06.2017 / 12:47
1
answer

Create and query Wp

Is it possible to create a table in the Wp database to insert values and change them, or would it block me? I wanted to create a simple table just to validate, insert a number and if necessary to change that number.     
asked by 18.08.2017 / 15:35
1
answer

Doubt - Insert table SQL Server 2012

I need to insert some information in the table called task, however, only when a certain condition is accepted that in the case are these two date fields, I put it to today for example if it were manual, that is, it would insert into the system...
asked by 05.10.2017 / 14:25