Posts by Guilherme Torres • 19 points

• -1

  votes

  3

  answers

  2032

  views

  A: Select from the last records sorted by 1 field

  Is the ID sequential and the date growing? If it is, you could get the last id - 3. Select * from TB where id >= (Select max(id) from TB) - 3 order by Nome

  sql-server tsql

  answered 8 years, 10 months ago Guilherme Torres 19

• 2

  votes

  4

  answers

  1630

  views

  A: Validate, if already exists does not INSERT

  Another solution for not having to make two requests in the bank is to make one Insert with select: INSERT INTO favoritos (id_user, id_oferta) SELECT ('$login_session', '$id') WHERE NOT EXISTS(…

  php

  answered 8 years, 10 months ago Guilherme Torres 19