Questions tagged as 'select'

Tagged questions
0
answers

INNER JOIN with a SELECT TOP

While generating a script, I tried to modify a where for inner join . However, the time when running with inner join was more than 10 minutes and with the where, it was in a matter of seconds, as the example below. I would like to know why th...
asked by 24.04.2018 / 15:01
1
answer

Select with pyodbc

I'm trying to use the string I get from an Entry and an OptionMenu to perform the search on SqlServer but gives the following error: TypeError: not enough arguments for format string Here is the function code that executes the call: def c...
asked by 18.04.2018 / 21:38
2
answers

Select / Where with paramerto does not work in Oracle

I'm doing a select with where via PHP and Oracle, when you get an error with the parameter:    Warning: oci_execute (): ORA-00911: invalid character in C: \ xampp \ htdocs \ project \ includes \ Read.php on line 52   Warning: oci_fetch_array...
asked by 13.04.2018 / 15:03
0
answers

Bring the value of one column according to the condition of another

I am developing a simple script but I came across a situation that I am not able to solve, I tried through CASE but without success. With a simple select I need to bring the columns Name, RG, CPF, and the CELLULAR telephone of the client , t...
asked by 17.04.2018 / 21:13
0
answers

Resolved Cursor.getColumnIndex () returns -1

I'm trying to make a select in the Android database, but every time I try, it generates an error. When doing debug I find that one of the columns, when doing getColumnIndex() is returning me -1 , causing an error in the applica...
asked by 10.04.2018 / 15:41
1
answer

Popular select of countries and states with php mysql ajax

I have 2 selects: #pais and #status. I want you to populate the state with only the states of that country, which are stored in a mysql table: tabela_paises id|pais 1|brasil tabela_estados id|idpais|estado 1| 1 |São Paulo the count...
asked by 29.03.2018 / 17:26
1
answer

How to validate the highest value received in mysql?

I have a query that returns me the last accesses of the users in the system. I would like to know how I could handle it to return only dates that were longer than 15 days. The query is this: SELECT u.id, concat(u.firstname,' ',u.lastname)...
asked by 23.03.2018 / 11:43
0
answers

Oracle - Lock that prevents SELECT

Lock that prevents SELECT The situation is as follows: An ERP application (Totvs) with several tables All these tables use as primary key a default field R_E_C_N_O_ The application (I believe) creates a new record common select max (R_E...
asked by 13.03.2018 / 21:16
1
answer

Save the total of rows from a SELECT with WHERE in a variable

I need to develop a code where the row total of a SELECT is stored in a variable. I wrote the code below, but when I use WHERE it returns a "Notice: Trying to get property of non-object in" error. Is it possible to do a SELECT using a WHERE...
asked by 04.02.2018 / 06:02
3
answers

Get the same result as a query with join

I have already researched some forums, looked at my books and searched other sources, but I did not find anything that solved my problem. I have a query that queries the open value in a given table: select negociacao_parcela.data_pagamento,...
asked by 22.01.2018 / 20:41