Posts by imex • 1,387 points

• 3

  votes

  2

  answers

  169

  views

  A: How to Make a Scan in SQL

  Here is a suggestion for testing using the function Max with the clause Over: select id, case when cpf_valido = 1 then max(id) over(partition by cpf) else id end as id_para, cpf from cliente…

  sql sql-server tsql

  answered 4 years, 1 month ago imex 1,387

• 2

  votes

  1

  answer

  56

  views

  A: CASE RETURNING MORE THAN ONE LINE IN A SUBCONSULTA

  Good morning, I think an alternative would be to use Top(1) with Order by within the subconsultation. As 'CREDIT' comes before 'DEBIT' in ascending order, the sub-allowance must return 'CREDIT' when…

  sql sql-server

  answered 4 years, 1 month ago imex 1,387