Questions tagged as 'select'

Tagged questions
1
answer

SQL query using order by filtering through the records [closed]

I have the table: | cod | hora | produto | Amostra | Min | Max | |-----|-------|---------|---------|-----|-----| | 1 | 08:00 | 96722 | 1 | 100 | 200 | | 2 | 08:23 | 96721 | 1 | 90 | 90 | | 3 | 08:50 | 96722 | 2...
asked by 06.09.2016 / 16:08
0
answers

Algorithm to match department, category and subcategory of a DB with an incoming string?

From a nonstandard string, sometimes I get the department / category equivalent, sometimes equivalent to category / subcategory, sometimes equivalent to department / subcategory, sometimes department / category / subcategory ... etc. . I need...
asked by 23.08.2016 / 14:52
1
answer

Select column with value *** of Excel

Good morning, friends! I need some help. I'm doing a "Select" from an Excel spreadsheet in VB.Net to import the data into the bank however a column is not bringing the data properly. This column has both numbers as * 's; when they are numb...
asked by 14.07.2016 / 15:28
1
answer

Sql Reader returning null value

I'm running a datareader , but it does not return any value, I've already checked the table and the conditions ( where ) of select exist in the table. The code follows below: public void consulta() { string sq...
asked by 04.06.2016 / 18:06
1
answer

"top" with MAX in mysql [closed]

I need to make an appointment that returns the top 3 salaries of public employees, by state. example that should return: fulano 850 RJ ciclano 800 RJ beltrano 700 RJ joao 1000 SP maria 900 SP pedro 200 SP I used M...
asked by 20.07.2016 / 13:23
0
answers

How to find select with no where in a laravel application [closed]

I have a problem and I can not identify where the laravel is doing a select without where in a table with many records, can anyone help me?     
asked by 24.05.2016 / 03:36
1
answer

Change email destination when clicking a select option on a form

Well, I have a form and I need it when selecting a select option to change: 1 line - action 2 line - value 3 line - value 15 line - Change where this is written sendOrca2 for eg enviaOrca1 <form id="formulario2" name="formulario2" me...
asked by 04.05.2016 / 00:32
1
answer

How to use two scripts in a single select (onechange)

I have a question: I have two scripts, one to change the image and another of the respective select, and another to make the calculation between them. I would like to use both for the same select, the problem is that one is used with: oncha...
asked by 21.05.2016 / 19:54
2
answers

Select with duplicate record

I have a question that may be trivial for most, but that I got stuck here, I look for a lot of research before posting, but I'll need a help. I'm building a select to bring me the closing of the results with base date, for this I need, for ex...
asked by 31.03.2016 / 14:11
1
answer

Execute an UPDATE in MySQL only when the number of rows equals 1

How to make a UPDATE only run when the number of rows that returned is equal to 1 in a single query only with SQL syntax using the example below? Example: SELECT count(*) AS rows FROM exemplo WHERE id_usuario = 100; if (rows == 1) {...
asked by 03.02.2016 / 17:17