Timeline for Select rows where column contains same data in more than one record
Current License: CC BY-SA 3.0
Post Revisions
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 2, 2014 at 10:46 | vote | accept | linurb | ||
| Jun 2, 2014 at 10:46 | vote | accept | linurb | ||
| Jun 2, 2014 at 10:46 | |||||
| Jun 2, 2014 at 10:45 | vote | accept | linurb | ||
| Jun 2, 2014 at 10:46 | |||||
| Jun 2, 2014 at 10:30 | comment | added | linurb | Yes, id is unique, but that's irrelevant to the problem. In the real table there are plenty of other columns that are not unique. What's interesting is that data (in the example) is not unique. | |
| Jun 2, 2014 at 10:28 | answer | added | Strawberry | timeline score: 6 | |
| Jun 2, 2014 at 10:22 | comment | added | Strawberry | @linurb But id is a PK, so it must be unique !?!? | |
| Jun 2, 2014 at 10:18 | comment | added | JPG | Then please edit your question to put a sample table with a better example. | |
| Jun 2, 2014 at 10:17 | comment | added | Dwza |
so if you have 3y and 5x and 1zyou want to have all listed without z ?
|
|
| Jun 2, 2014 at 10:17 | answer | added | fancyPants | timeline score: 7 | |
| Jun 2, 2014 at 10:17 | comment | added | linurb | @JPG: Because I don't know that it is 'y'. It's just an example. What I know is that I want all rows except those where a particular column has a uniqe value. | |
| Jun 2, 2014 at 10:15 | comment | added | linurb | In this example, yes. But in general where the contents of one column is equal irregardless of the contents of the other columns. | |
| Jun 2, 2014 at 10:14 | comment | added | JPG | why SELECT * FROM table WHERE data = 'y' does not apply to you? | |
| Jun 2, 2014 at 10:12 | comment | added | Strawberry | So where the data is equal, but the id's aren't? | |
| Jun 2, 2014 at 10:10 | history | asked | linurb | CC BY-SA 3.0 |