March 10, 2008 at 1:55 pm
I have to list the title_id, type, pub_id, price, and royalty of all books. If the royalty has an indeterminate value, the result set should give a royalty value of zero. The result set should be given in order of decreasing royalty.
How in the world do I write this? I'm trying my best to understand this in my homework, but I'm having a very hard time and am also "very" behind. I'm so afraid I'm going to fail this class because the only dealing I've had with Sql was a "beginner's" class. This is way over my head, I'm afraid.
PHG
March 10, 2008 at 2:01 pm
Well right - it's homework, so you need to do most of the heavy lifting.
A few questions might help you along though:
- what's the term used in databases dealing with the concept of "indeterminate values"? Meaning - columns that don't have a known value are _ _ _ _ columns.
- what built-in function (which mentions the _ _ _ _ from q. 1 as part of its name) would allow you to replace a _ _ _ _ with something else?
- Ordering from biggest to smallest is to sort in _ _ _ _ _ _ _ _ _ _ order.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply