Timeline for SELECTing multiple columns through a subquery
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Jan 26, 2016 at 9:32 | history | suggested | robsch | CC BY-SA 3.0 |
formatted code
|
| Jan 26, 2016 at 9:11 | review | Suggested edits | |||
| S Jan 26, 2016 at 9:32 | |||||
| Jul 15, 2013 at 8:10 | history | tweeted | twitter.com/#!/StackDBAs/status/356687117499375617 | ||
| Apr 15, 2013 at 13:23 | answer | added | druzin | timeline score: 7 | |
| Mar 16, 2013 at 13:06 | review | Close votes | |||
| Mar 21, 2013 at 3:04 | |||||
| Feb 14, 2013 at 6:07 | history | edited | BufferStack | CC BY-SA 3.0 |
typo
|
| Feb 14, 2013 at 6:06 | comment | added | BufferStack |
@Michael-sqlbot - Yes, that's exactly what I am trying to gather. The deviceID is from pets table - meaning that just do not get me the pets which are submitted by 'ABC' himself.
|
|
| Feb 13, 2013 at 23:53 | comment | added | Michael - sqlbot | If you had an index(petid,id) on the comments table, the order by would not likely be slow, but first things first: It seems as though your query is asking for all of the pets where userid 'ABC' has commented on them within the last two months, where deviceID isn't 'ABC' (though it's unclear which table deviceID is a column in, possibly pets and possibly comments) and who the last commenter was, and the last comment date. Is that right? | |
| Feb 13, 2013 at 14:19 | answer | added | Valkyrie | timeline score: 14 | |
| Feb 13, 2013 at 13:04 | history | edited | BufferStack | CC BY-SA 3.0 |
added 12 characters in body
|
| Feb 13, 2013 at 12:58 | history | asked | BufferStack | CC BY-SA 3.0 |