Posts by João Rodrigo • 11 points

• 1

  votes

  2

  answers

  1494

  views

  A: How to get the first result of duplicate lines?

  Have you tried this? (This syntax may vary depending on the database, this is for sql server) SELECT TOP 1 fk_nota_fiscal, fk_produto, valor, campo2, campoXXX FROM table_name; Or distinct? SELECT…

  sql-server

  answered 8 years, 1 month ago João Rodrigo 11