I want to retrieve records from multiple tables using Join operation.
See below is my table:
Table Name : country
+--------+-------------
| Field | Type
+--------+-------------
| c_id | int(5)
| c_name | varchar(30)
+--------+-------------
Table Name : company
+----------+-------------+...
I am attempting to write a query that will take a date value and return a numerical value. What I plan to use this for is to track the days until an inspection is due. For example I will input the inspection expiration date into the database, then I want the query to return the value of days rema...
I have a table that stores pizza orders. The table has a value called quantity; the amount of pizzas in that specific order. I need to "create a query that gets the distribution of orders against different pizza quantities in an order. The questions states"Your sql query should count the number o...
Not saying it's your fault, of course, or maybe it is helping and I would have seen 10 instead of 3, it's just clear that some people you're never going to be able to help no matter how much info you spoon-feed them.
I love this but it would be even better if the platform text prescribed that usually they want to pick only one platform. We stillgetlots of people tagging both mysql and sql-server, and in almost every single scenario it is just wrong (or maybe I have too much faith and they're over-tagging intentionally). — Aaron Bertrand17 mins ago
@Kermit Yeah, it's tricky though, because what if someone is doing a MySQL -> SQL Server migration, or setting up a linked server from SQL Server -> Oracle? I think there are legit use cases for picking multiple platforms (but it's 1 out of 100 - with the other 99 just being tag stuffing or cluelessness)
James is a pretty big authority in the PDW world, I think his questions in there are at least somewhat rhetorical and could be interpreted as "these are the questions you need to ask"... I
Trying to display the total sales for the dates 07/10-07/13. Also trying to have the results displayed with each day as a column.
Got it to work, but the code is so messy and complicated that my instinct tells me there has to be an easy way to write this.
Can anyone point me in the right dir...
But you might as well suggest keeping the original code and removing the output clause as a "workaround" then. The only issue that needs working around is the unexpected result of that. — Martin Smith29 mins ago
I cannot understand why they say "delete with window functions is not set based".