Jump to content
Fórum Script Brasil
  • 0

DISTINCT em mais de uma coluna


Felipe Matos
 Share

Question

3 answers to this question

Recommended Posts

  • 0

Bom dia Felipe,

Seria isto que deseja? Criei uma temporária e inseri alguns valores para testes:

create TABLE #Teste (campo1 INT, campo2 INT, campo3 INT)

INSERT INTO #Teste VALUES (5,10,20)
INSERT INTO #Teste VALUES (5,10,30)

SELECT DISTINCT campo1, campo2 FROM #Teste

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Forum Statistics

    • Total Topics
      149.6k
    • Total Posts
      646.2k
×
×
  • Create New...