Posts by PedroDN • 19 points

• 1

  votes

  0

  answers

  85

  views

  Q: PIVOT Help - SELECT SQL

  I have a table with the data: unidade tipo valor 1 2 10,00 1 3 15,00 2 2 16,00 3 3 10,00 3 1 25,00 I need to make a select with pivot that brings me unidade tipo1 tipo2 tipo3 1 0,00 10,00 15,00 2…

  sql select pivot

  asked 8 years, 2 months ago PedroDN 19

• 0

  votes

  2

  answers

  204

  views

  Q: SQL Select Where

  I need to make a SELECT in a table containing ID, VALOR, DATA and NOME. The result has to bring only the lines on which the was the biggest date existing. Example: ID VALOR DATA NOME 1 100…

  sql query select logic where

  asked 8 years, 6 months ago PedroDN 19