Questions tagged as 'query'

Tagged questions
1
answer

Do SELECT with average user ratings

Well, I'm developing a project and it has the list of people, I would like to list them based on the average of the evaluation, I tried to do with INNER JOIN and AVG, but with them they will not show users who have just registered. The SELECT th...
asked by 08.11.2018 / 13:02
1
answer

VBA Excel - Index Match with two conditions

I have a spreadsheet with multiple tabs. On the first tab I have the following table: Intab2,typetheclientandtype,andIwanttoreturntheID.ForthisIamusingthefollowingcodeinVBA:tipo=ActiveCell.Offset(0,-1).Valuecliente=Range("D5").Value ActiveCell....
asked by 18.07.2018 / 20:50
1
answer

INSERT WITH TWO TABLES - PHP

I have the student table and the payments table, I'm doing a gym system. I have listed the two tables by putting student_id in the payments table as a foreign key. I want you to enter the data together of these two tables on the screen wh...
asked by 24.09.2018 / 17:10
1
answer

Return range of Oracle PL / SQL strings

Good morning! I need to return the value inside a string that is between a range of | in the select below I can get the value from the first | . The expected result is: 83,1 SELECT SUBSTR('1410,00|83,1|39,29|1410m|',...
asked by 19.07.2018 / 13:16
2
answers

How to write SELECT result?

I need to insert data into a table A, but I have an unknown data and I need to search it in table B. So, I need to do a SELECT on table B and save it for later insertion into table A. I have achieved the expected result, but it is a pallia...
asked by 09.01.2015 / 19:43
2
answers

Rails - check for non-matching records

I have a Rails application and I'm creating a notification system, the problem is that I do not know how to query for notifications not seen by a user in a practical way. The schema of the notification table is as follows: create_table "not...
asked by 18.06.2018 / 20:41
1
answer

Query string pagination with codeigniter

How can I do paging with query string in CodeIgniter? I'm trying to search the documentation but I have not found it! I have the following scenario: http://localhost/meusite/procurar/s?search_state=RJ&search_city=Rio+de+Janeiro If it wa...
asked by 08.05.2018 / 18:09
1
answer

mysql error: each derived table must have its own alias

I am trying to join two tables questionario and resposta and select from the table questionario two dates, this was the code I tried in php: $verificar=mysqli_query($link,"SELECT questionario.*, resposta.* from questionari...
asked by 08.06.2018 / 17:09
1
answer

Media Query for different zoom levels?

I would like to use '' values in Media Query, but for different zoom types in the browser like 100% co_de 125% and so it goes. What values should I use?     
asked by 01.04.2018 / 21:05
1
answer

How to sort varchar field with letters and numbers in sql server

I have the following query below and would like to sort by image, but the number. WITH cteNiveis(IdConta, NivelRec, NomeTab, Caminho, Nivel, Tipo, Status, Nome) AS ( SELECT CO.Id, 1 , CAST(CO.Nome AS VARCHAR(MAX)) AS NomeTab, CAST(...
asked by 06.04.2018 / 15:25