Posts by Almino • 37 points

• 0

  votes

  1

  answer

  58

  views

  Q: Subquery returns more than one result

  Good afternoon! I have the following query that counts the total number of subscribers per course. I want to find the largest amount of subscriber according to code: WITH CTE AS( SELECT IDPS,…

  sql case cte union-all

  asked 3 years, 11 months ago Almino 37

• 0

  votes

  1

  answer

  51

  views

  Q: Concatenate values with condition (case)

  Good evening! I’m new to the programming. I have the code below in a CTE that counts the number of subscribers in each area. In the main consultation I see which area has the largest amount of…

  sql string-concatenation case cte

  asked 3 years, 11 months ago Almino 37

• -2

  votes

  1

  answer

  120

  views

  Q: Subconsulta returns more than one value

  Good night! I have an sql query based on a CTE and I want to take the largest value between a subconsulta, but when I run the main query the subconsulta error returns more than one value appears.…

  sql sql-server query cte union-all

  asked 3 years, 11 months ago Almino 37

• 0

  votes

  2

  answers

  84

  views

  Q: Union All specify select no order by

  I have ONE test table and I’m doing a Union All and I want to sort by date but not sort by the first select before Union All which would be a headline. I would like to order only the data of the…

  sql order-by union union-all

  asked 3 years, 11 months ago Almino 37

• 1

  votes

  0

  answers

  25

  views

  Q: CSV file does not record all data in the database

  Good evening, in my code when I send the CSV file It records only the last line of the file, when I use TRUNCATE TABLE. Without the truncate saves all lines, but the goal is to update the data by…

  php sql csv

  asked 4 years, 3 months ago Almino 37

• 0

  votes

  1

  answer

  42

  views

  Q: Foreach - Conditions within a period

  Is it possible to place an if/Else condition inside a foreach? Below part of a code, where you enter the date range in the bank via $_POST. The question is: Is it possible to place an if/Else within…

  php sql date foreach

  asked 4 years, 6 months ago Almino 37

• -3

  votes

  1

  answer

  30

  views

  Q: Undefined Property: Dateperiod::$format

  I am making a system that registers a set of dates via $_POST. I want to insert in the database the range created below via datetime. But when executing appears the above message. How to proceed?…

  php mysql datetime

  asked 4 years, 6 months ago Almino 37