When I was 17 and they decided to migrate to Oracle I didn't have a personal guide to teach me how the group by clause worked or subqueries, I had to climb uphill both ways to my keyboard, you should feel lucky :P
conveniently they worked the same way as in T-SQL :)
@WorldEngineer I had a query above with statistics, @Dynamic wanted a column with the sum of all the statistics per user
super easy change to the query where the query already has an example, but he's on mobile
Sum of don't mention sleep or else I might pass out, and I promised my wife I'd wake her from her nap shortly and we'd hang out and watch the Dr. Who xmas special
What industries are most likely to practice software engineering with the engineering rigor + depth and breadth defined in the SWEBOK? (i.e. software engineering with all the project planning, requirements engineering, software design, implementation based on the design, testing, deployment, awar...
If anyone here agrees, vote to reopen and upvote it so it can get some attention. I think we all kind of know intuitively aerospace and healthcare are the two biggest ones that come to mind (ventilator software for example which I used to work on)
I am curious what others people know of. factory automation perhaps
@Dynamic @Walter @JimG. @Oded @GlennNelson I've edited this question to make it answerable, please vote to reopen if you agree or let me know what else I can do to make it more constructive
I've been learning SQL recently and practicing with MySQL/Postgres and soon Oracle DB. I've also search the web for a 'road map' study of databases but couldn't find one, unfortunately.
I'm curious where each database concept falls on the scale from beginner to intermediate and advanced. I'm th...
@JimmyHoffa It's still not constructive... what I think is a beginner/intermediate/advanced concept may not be the same as what the OP or you or Barack Obama thinks is beginner/intermediate/advanced.
getting different opinions on answers is totally common on this site anyway. You ask about an architectural design approach and some people will tell you it's great and some will tell you it's terrible
just because people have differing opinions on something doesn't mean it shouldn't be asked
@JimmyHoffa I think the answers are great, but the question not so much. I think it has value on the site, even closed, especially if you can take some of Chris' thoughts and add it to your answer (with attribution, of course, and if you agree with the differences).
There have been questions that are not appropriate for the site that have been allowed to stay because they were canonical for their topic. this has that kind of feel for me, anyway.
Leaving stuff around for "some time" is a concession to calm people about the inevitable deletion. if closed stuff was deleted after 1 week people wouldn't close so much perhaps
@Walter nope. all closed questions will be deleted if not merged as dupes
Don't vote to reopen it and you are voting for deletion. Maybe not today or tomorrow but @YannisRizos says all closed questions that are not dupes will be deleted if not reopened.
So you think it's good and beneficial, but won't be in 2 months or 4 months or however long before it's "cleaned up" ?
for questions that aren't being improved. you're working on improving this.
post a question on meta asking for help on getting the question fixed. bring others into the process. the question won't get deleted today, or tomorrow or even this week...
I've been learning SQL recently and practicing with MySQL/Postgres and soon Oracle DB. I've also search the web for a 'road map' study of databases but couldn't find one, unfortunately.
I'm curious where each database concept falls on the scale from beginner to intermediate and advanced. I'm th...
The Whiteboard
The Whiteboard