CODEWITHSUNDEEP
sql-server
Ram
Ram

Reputation: 337

How to fetch unique values from two tables in sql?

Table1:

id  name  design  AddrId
1   Ram   SE        101
2   Ravi  JSE       102
3   Vas   SSE       103

Table2:

AddrId   MobNo   EmailId 
101      78945   a@gmail
101      54675   b@gmail
102      12345   c@gmail
103      45687   d@gmail 
103      64587   d@gmail

In second table I have duplicate values. I need only unique values. like here I have two different addresses with same ID, so can I get first one. I need all values(unique) from first and second tables. can any one help this.

Upvotes: 1

Views: 122

Answers (1)

Vignesh Kumar A
Vignesh Kumar A

Reputation: 28403

Try with Row_Number

SELECT * FROM
(
SELECT *,ROW_NUMBER() OVER(PARTITION BY AddrId ORDER BY AddrId ASC) AS RN 
FROM TABLE1 
     JOIN TABLE2 ON
     TABLE1.AddrId =TABLE2.AddrId
) AS T

WHERE RN = 1

ROW_NUMBER

Upvotes: 2

Related Questions