Timeline for How to total additional results from alias column results in Oracle SQL?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 3, 2016 at 20:20 | vote | accept | alexanderjsingleton | ||
| Mar 3, 2016 at 20:18 | answer | added | Balazs Papp | timeline score: 1 | |
| Mar 3, 2016 at 20:03 | history | edited | alexanderjsingleton | CC BY-SA 3.0 |
Added requested picture.
|
| Mar 3, 2016 at 20:01 | comment | added | alexanderjsingleton | @JustinCave, I basically trying to display two alias-columns, one displaying the difference of days between two columns in the table, and then another alias column displaying the number of instances with the same number days between the previously mentioned dates. Does that make sense? | |
| Mar 3, 2016 at 19:47 | comment | added | Justin Cave |
I'm not sure that I understand exactly what you're trying to accomplish. Some sample data and expected results might be quite illustrative. Are you trying to determine the number of invoices where the difference between the two dates is 1, the number of invoices where the difference between the two dates is 2, etc.? In which case you just need a GROUP BY and potentially a trunc. Or are you asking for the number of rows between an invoice_due_date of x and an invoice_date of y (in which case we'd need to understand what you mean by "between").
|
|
| Mar 3, 2016 at 19:38 | history | asked | alexanderjsingleton | CC BY-SA 3.0 |