What is the SQL statement if you want to retrieve the following data?

I am not good at sql, so please let me know.

"I would like to extract ""Contractor ID_PK"" and ""Regional Number"" from the following contract information TBL."
The extraction conditions are a list of non-overlapping county numbers for each contractor ID.
Thank you for your cooperation.

◾ 情報Contract Information TBL

Contractor ID_PK Contract Number_PK Affiliate Country Number...
aaa00101
aaa00201
aaa00302
bbb00101
bbb00202
bbb00302
ccc00101
ccc00201
ccc00301

◾

Contractor ID Country Number
aaa01
aaa02
bbb01
bbb02
ccc01

sql

2022-09-30 21:35

1 Answers

SELECT DISTINCT Contractor ID_PK, Affiliate country number FROM contract information TBL

I see. DISTINCT removes duplicate lines from the results.

2022-09-30 21:35

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656