Questions tagged as 'consulta'

Tagged questions
1
answer

How to execute a transaction within a Command

I am making an application that will register an order and for that I need to use the transaction sentences. I have developed an attempt that I will attach below and the following error:    Unhandled exception of type 'System.InvalidOperation...
asked by 31.10.2018 / 14:04
2
answers

delete repeated values sql server

I have a problem in a sql server query ... I have this table where I need to delete repeated values (those marked in blue) due to the last column ('hh''mm') and try the DISTINCT but even so he shows them to me I do not know if I made my...
asked by 26.10.2018 / 20:46
2
answers

Problem with mysql and php

I have the following doubt, I am doing a search engine, that I look for in my database a product that contains some letter in its name, I make the query in phpmyadmin and all good, it works for me, the problem comes when I pass by parameter from...
asked by 09.09.2018 / 07:47
1
answer

SQL query Advanced filter with Postgres

I have this database model I want to make a query that meets the following conditions. all students must be listed I want to be able to see the type of characterization only of the characterization with the highest order semester...
asked by 20.11.2018 / 06:31
1
answer

Group results in MYSQL applying inner join

I'm trying to group 3 related tables this would be the sql code SELECT * FROM metadata_values mvalues INNER JOIN metadata_descriptors mdes ON mdes.idDescriptor = mvalues.idDescriptor INNER JOIN metadata_schemas mschema ON mschema.idSchema = md...
asked by 21.08.2018 / 22:14
0
answers

Generate and call database queries before or within html? [closed]

Well, I looked for this question, but I did not find any questions like this about the database queries only for the JavaScript or JQuery code. What is the best practice, call the database queries before starting HTML or inside the body? (I make...
asked by 16.08.2018 / 13:17
2
answers

Error in php query

I have the following code that should print me the amount of products registered in a table <?php require_once "js/conexion.php"; $sql = 'select count(idp) as total from producto'; $result = $mysqli->query($sql); if(!$r...
asked by 01.11.2018 / 06:42
3
answers

SQL query in MySQL between 3 sum and count tables

I have 3 tables. One is clientes , other fotocopias and recargas_saldo , related by id_cliente which is primary key in clientes and foránea in the others. I need to take out the following: 1 .- No...
asked by 17.10.2018 / 13:16
2
answers

Percentage in SQL grouped by column

I have the following table structure: From which you want to take the percentage of the value that comes in the loans column grouped by number. of cuit. I have tried this but in all cases 100% comes to me SELECT cdd.NumeroI...
asked by 19.04.2018 / 17:06
1
answer

Get the number of rows of an SQL query

I have a problem in a query, in this query I have the students enrolled in a section of a specific year and their averages. My goal is how I can get the number of students who pulled at least one course in that year. select N.Descripcion as Ni...
asked by 18.10.2018 / 01:22