Questions tagged as 'select'

Tagged questions
1
answer

C # How to Select and Color all text within a given row in RichTextbox?

In C # I have a RichTextbox, inside it has several lines, what I want to do is to select all text within a given line and color. What I'm doing is this: richTextBox1.Select(0, richTextBox1.Lines[index].Length); richTextBox1.SelectionColor = Co...
asked by 06.01.2018 / 23:29
2
answers

Duplicate the result of Select Postgresql

I have a record that is a receipt, and in select, I want the line to be duplicated. Ex: Select * from recibos where codigo =1; Result: codigo|cliente|valor|emitente|data 1 Fulano 10 Ciclano 19/10/2017 Result I need: codigo...
asked by 19.10.2017 / 18:44
3
answers

Select query by age group

I made a query select like this: SELECT data, sexo, idade, count(*) qtd FROM marcacao group by data, sexo, idade And I get a table similar to the table below: DATA | SEXO | IDADE | QTD 01/07/2017 | F | 30 | 3 01/07/20...
asked by 24.07.2017 / 14:21
2
answers

Check if there is a record in the table

I'm trying to check if there is a record in the mysql table using php, I have the table "slug", and in this table I have "id" and "slug_name", as I do to check if there is already a name in this table, for example: noticia_sobre_o_tempo. how...
asked by 24.07.2017 / 15:17
1
answer

Oracle procedure return query rows

I have the following table: CREATE TABLE CARRO ( CD_CARRO INT ,DONO VARCHAR(20) ,MARCA VARCHAR2(20) ); The inserts INSERT INTO CARRO VALUES (1,'VICENTE','FERRARI'); INSERT INTO CARRO VALUES (2,'CARLOS','FUSCA'); INSERT I...
asked by 29.03.2017 / 15:26
2
answers

how to change the subtitle of the page with the selection of a select

Galera is very simple, I have a form that can serve multiple services. I need the subtitle of the page to change depending on the choice (in a select) of the service. I'm using the following a bit of code <header class="jumbotron">...
asked by 03.02.2017 / 18:27
2
answers

How to select single data from a conditional join?

I have 2 database tables: servers +----------+--------------+ | Field | Type | +----------+--------------+ | id | int(11) | | ip | varchar(255) | | votes | int(11) | | port | varchar(255) | | hash...
asked by 13.11.2016 / 20:33
1
answer

SELECT problems with postgresql

I am doing a migration from mysql to postgres, but there is a mistake, not much experience with postgres: SELECT SELECT m.* , (SELECT c.id FROM corridas c WHERE c.motoqueiro = m.id AND (c.s...
asked by 09.08.2016 / 17:10
1
answer

How to do a SELECT with Entity Framework?

I'm developing a kind of a QUIZ in C #, and I've already been able to do the INSERT questions and the answers in the database, but I'm having a hard time bringing the question and the bank's response to the quiz. Type a select, because I just...
asked by 08.08.2016 / 22:26
3
answers

Use of select with function SUM ()

I'm developing a database for a small application. My bank has 3 tables: students, disciplines and school_letter, the latter used to insert 3 individual notes. I have been able to calculate the average of these NOTES through the SUM () fun...
asked by 27.07.2016 / 16:12