Questions tagged as 'select'

Tagged questions
4
answers

Problem with the use of count in sql

I have a table with the following data named registers : -------------------------------------------------------------- id_plague | id_production | quadrant -------------------------------------------------------------- 4...
asked by 08.09.2017 / 16:11
3
answers

Load an array in select - Javascript

I have a form in a document HTML with a field select where I charge several provinces. Is this way to load the provinces in the Select correct? I get an error. <select name="provincia" id="provincia"> <option value="...
asked by 14.05.2017 / 17:22
2
answers

Get selected option within an optgroup

Having a select like this: <select id="main"> <optgroup label="Coches"> <option value="Mustang">Mustang</option> <option value="Ford">Ford</option> </optgroup> <optgroup label="...
asked by 20.03.2018 / 13:06
1
answer

Values of a Select - Javascript

Unable to modify the HTML, only with Javascript perform the following operation: I have a SELECT with four possibilities: <select name="tipo" id="tipo"> <option selected value="none">Elige uno...</option>...
asked by 25.05.2017 / 14:10
1
answer

SQL query. Joins

Place value of a table2 in a query to table1. I have a query in SQL SELECT ROW_NUMBER() over (partition by IdCertificado order by FechaCambio) Consecutivo, upper (IdCertificado) IdCertificado , IdTipoSolicitud , cast (FechaCambio AS date)...
asked by 31.07.2018 / 21:50
1
answer

SELECT MYSQL query unrelated tables

I have the following table called purchases And a sales call of which I need to obtain a total sum grouped by month. Just to give an example of what I'm trying to do, I have this query. SELECT * FROM (SELECT DISTINCT MONTH(creado)...
asked by 19.09.2018 / 00:07
1
answer

Count rows - judgment result in the query

I need to count the rows that result in this statement (it works correctly and I know it returns a single value): SELECT comp.descripcion FROM componente AS comp, pieza AS pza, pieza_equipo AS pzaequip, equipos AS equip WHERE comp.codigo = p...
asked by 16.04.2018 / 18:11
1
answer

Query about SQL INNER JOIN SELECT TOP 1

I have the following question: in a table I have a ID that is related to the other table, but the daughter table has several ID of the table Father then at the time of doing the INNER JOIN brings me N records. I'm tr...
asked by 13.06.2017 / 18:55
1
answer

Set up a select without using php?

I currently have a situation that really may not be the big deal, but I have tried to search everywhere and I really have not found the answer to my problem. Well, we all know that the <select> tag is used to create a list of...
asked by 25.09.2018 / 23:44
2
answers

Problem in MySQL Select query

I have a problem in a Query in MySQL, I currently have two tables, one of employees and one of places visited by that employee by date, the goal is to obtain through a query the list of all employees and the last place they visited, so far so go...
asked by 05.09.2018 / 20:17