CODEWITHSUNDEEP
mysqlsql
shree
shree

Reputation: 2757

How to query in sql with duplicate records?

Hi i have ITEAM A and ITEAM B table. For example

 Table 1)     ITEAM A

ID   DATA
1    J
2    C
3    P

Table 2) ITEAM B

ID   DATA
1    C
2    P
3    J
4    R

Expected Result

Result:
C
C
J
J
P
P
R

How to fetch records combined ITEAM A and ITEAM B with ascending order and duplicate records in sql? please help someone

Upvotes: 0

Views: 46

Answers (2)

Shameem
Shameem

Reputation: 317

SELECT `DATA` FROM ITEAMA UNION ALL
SELECT `DATA` FROM ITEAMB ORDER BY `DATA`

Upvotes: 1

Akina
Akina

Reputation: 42834

SELECT data FROM tableA
UNION ALL
SELECT data FROM tableB
ORDER BY data

Upvotes: 2

Related Questions