Questions tagged as 'select'

Tagged questions
1
answer

SQL query help

I have 3 tables: Company: id integer nome string category: id integer idEmpresa integer nome string tag: id integer idEmpresa integer nome string I'm querying as follows: SELECT distinct(e.nome), e.id, e.logo FROM empresas e,...
asked by 01.04.2018 / 18:00
2
answers

Select only if the ID is in 2 tables [closed]

I have 2 tables in Mysql, INSCRICAO1 and INSCRICAO2 . Both have a field called COD that receives a user code. A INSCRICAO1 saves the user's personal information INSCRICAO2 stores user's car information I need to select only INSCR...
asked by 03.04.2018 / 22:27
1
answer

Filter problem using class="selectpicker" in filter select,

Good afternoon, could anyone help me with this problem? I have no idea what's going on .... Next, I have a select that selects the city, and then the follow-up as selected in the city, so far, it works and everything, but I just put the class...
asked by 31.01.2018 / 20:12
2
answers

How to join these 2 SELECTs in the same query

Good morning, I'm redoing the question because the last one I deleted because it was a bit confusing. I have these two select and would like to join them to return the result for a comparison chart. This SELECT query and returns me the nu...
asked by 01.02.2018 / 15:23
2
answers

Bring repeated records of 3 columns in the same table

I have a table with transport data from my company employees: nome ! valor1 ! valor2 ! valor3 teste1 ! 6.50 ! 0.00 ! 0.00 teste2 ! 4.30 ! 2.80 ! 1.10 teste3 ! 8.40 ! 1.10 ! 0.00 teste4 ! 2.85 ! 1.10 ! 0.00 Where it is possible for the empl...
asked by 16.01.2018 / 19:43
2
answers

Select returning dates on object other than what is registered in MySQL database

I'm having a problem when I'm writing the contents of a table and storing it in a list so the date is one day less. I've done a lot of research on the web and I did not find a solution to the problem. Below the registration method: publi...
asked by 26.01.2018 / 22:00
1
answer

Select within for

Next, my question is more about logic anyway .. I have a python script in which I use psycopg2 to perform searches in the database. But I need to do this within a for. I have full notion that doing a search within a for can affect and much in c...
asked by 12.12.2017 / 12:32
1
answer

Returning select value with javascript / jquery

I'm developing a software and I need to know which option the user selected and returned in the console.log, but I tried several functions and none worked. How do I get this return? function verificar() { // aqui seria a fu...
asked by 18.12.2017 / 18:33
1
answer

Doubt with select case

I have the following query: select f.no_equipe, i.no_cbo, count(b.tp_atend) from tb_equipe F, tb_cds_prof G, tb_cbo I, tb_cds_ficha_atend_individual D, tb_cds_atend_individual B where F.nu_ine = G.nu_ine and G.nu_cbo_2002 = I.co_cbo_2002...
asked by 18.12.2017 / 14:19
2
answers

How do I mark options in ajax return?

I have an array of ids and I'm returning this array in the ajax response. How to compare this array with the select options and mark the option if it matches the index of the array? In PHP, we use the in_array () var options = data.opti...
asked by 30.11.2017 / 18:32