User Profile

Collapse

Profile Sidebar

Collapse
dbstudent
dbstudent
Last Activity: Dec 4 '12, 10:35 PM
Joined: Oct 25 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dbstudent
    replied to Help with Order By AND ROWNUM by a student
    in Oracle
    WOW! You are amazing.....tha t answer worked like a charm....don't know why my book doesn't lay it out in those terms....
    Sorry about the incorrect format, I will get it right next time.
    Thanks!
    See more | Go to post

      Leave a comment:

    • dbstudent
      started a topic Help with Order By AND ROWNUM by a student
      in Oracle

      Help with Order By AND ROWNUM by a student

      I've tried several scripts and NONE of them have worked. I need to apply the Order By first, then limit to the top 10 Rows. Here are two I've tried, with both i'm getting a "command not properly ended" message:


      --Question 8c 4 columns from Invoices table with alias' and two calculated columns and filter and sort with ROWNUM

      Code:
      SELECT  invoice_number AS "Number", invoice_total AS "Total",
      ...
      See more | Go to post
      Last edited by Rabbit; Oct 25 '12, 06:07 PM. Reason: Please use code tags when posting code.
      No activity results to display
      Show More
      Working...