Questions tagged as 'select'

Tagged questions
1
answer

SQL select with dynamic where in ABAP

Is it possible to create a select with dynamic where in the abap language?     
asked by 13.12.2017 / 19:21
3
answers

Select Sum in Table with PHP / Mysql

I have a table with the following fields: date, time and quantity . And I need to do a select sum addition. To understand better, I have a form where I insert a date, after I insert, I will make an appointment in the bank and in it I need to...
asked by 03.06.2017 / 17:30
3
answers

How to do subquery with pdo

I would like to perform a subquery within this query: $ranking = $pdo->query("SELECT * FROM usuarios_emblemas GROUP BY usuario ORDER BY count(usuario) DESC LIMIT 3"); It would be to block the list of users with banned = true, ie I want t...
asked by 05.07.2017 / 19:13
3
answers

PDO paging - Problems with prepare (); select ();

Hello, I'm having trouble printing data from a table. Update : I put the following lines in the connection.php file: public function select(){ $sth = $this->prepare("SELECT id_prato, titulo, descricao, preco FROM prato"); $t...
asked by 18.05.2015 / 01:27
2
answers

Select items that do not contain a 2nd table

I need to select data from a table only when the codigo of this table is not in a second table. Briefly that would be it. I have the entregaitem table with the following (codigo,codigoentrega,codigoestoque) columns and the...
asked by 23.10.2017 / 15:09
3
answers

Identifying SQL Brothers

I've put this link as an example of where I want to go link I have the student table. Ihavethetablewiththesibsids Myproblemis,IneedtodoaselectinsuchawaythatIcanonlymakeonenameappearatatimeandproduceanIDtolinkthesiblings: WiththisquerySELEC...
asked by 18.08.2017 / 18:54
1
answer

Adding records with type_type in another table

I have 2 tables linked by id and I need to add a field in table 2 by grouping through a field in table 1 -----TABELA 1----- ID_tab1 - tipo_pgto -----TABELA 2----- ID_tab2 - ID_tab1 - valor_pago I want you to show me the sum of the amount p...
asked by 17.11.2015 / 05:18
3
answers

Exception in sql query

How do I display items from my MySql database in php, so that I select all items except one item. Ex: I have several registrations ... item 1 | id01 item 2 | id02 item 3 | id03 item 4 | id04 item 5 | id05 item 6 | id06...
asked by 29.06.2015 / 17:10
2
answers

SQL query filter

I have a field called emailMSG0 inside a table in the database. This field contains various information. Is there any possibility in SQL to filter what I want to get inside this emailMSG0 field? Bring just some information. If I...
asked by 19.05.2016 / 13:51
2
answers

Select where in in LINQ

How to convert the code select down into LINQ? select * from producao where id not in (select idProducao from bpi)     
asked by 17.02.2017 / 14:45