Home>
Students learning languages with Progate.
I'm solving a problem as part of language learning, but I'm stuck with the problem of "extracting only data with multiple types of name identification with a single name identification number".
[Image]
[Original data]
Name-matching name | Name identification number |
---|---|
Ah | 1 |
Yes | 2 |
Yes | 2 |
U | 3 |
Eh | 3 |
Oh | 4 |
Oh | 4 |
or | 4 |
ki | 5 |
ki | 5 |
< | 5 |
< | 5 |
K | 6 |
This | 6 |
Sa | 6 |
[Data to be retrieved/Extracted data]
Name-matching name | Name identification number |
---|---|
U | 3 |
Eh | 3 |
Oh | 4 |
Oh | 4 |
or | 4 |
ki | 5 |
ki | 5 |
< | 5 |
< | 5 |
K | 6 |
This | 6 |
Sa | 6 |
I want to output the above result.
[Unnecessary data/Non-extracted data]
Name-matching name | Name identification number |
---|---|
Ah | 1 |
Yes | 2 |
Yes | 2 |
This is data that does not need to be displayed, but it is included here just in case.
I thought about SQL statements that display duplicate data and SQL statements that use exists.
Cannot output.
In this case, what steps can be taken?
Please give me a professor.
MySQL
-
Answer # 1
Related articles
- mysql table creation multiple foreign key error
- mysql i want to compare multiple items of the same record and get the minimum
- c # - i want to get multiple control names (serial numbers) dynamically
- how to execute multiple queries in routing with nodejs, mysql
- mysql - is it ant to give the same index name to multiple tables in sql?
- how to start multiple servers on the same host in mysql8 and perform replication
- mysql - best practices for table design with multiple parent tables
- mysql - i want to use a form that handles multiple models using form_with and fields_for
- entering a p tag with multiple class names written in php variables breaks on html
- The basic types of MySQL best practice partition table
- windows - local dns: want to link multiple service names to one ip address
- mysql - about database field names
- mysql - transaction when multiple apis are hit in a series of processing
- CentOS75 uses MySQL_multi to install MySQL 5728 multiple instances (detailed)
- Python implementation to pass json multiple rows of data into mysql for use
- Getting Started with MySQL Multiple Tables
- Mysql backup multiple database code examples
- how to reference numbers from multiple tables in mysql
- Mysql index types and basic usage examples
- i want to put multiple assignment expressions in a mysql if statement, but i get an error
Trends
First grouping process
Filter this by multiple cnts (>1)
End of parenthesis
The num extracted here and the outer table num
Use where exists to narrow down