Oracle SQL in TOAD

30 pts.
Tags:
Oracle
PL/SQL
SQL
TOAD
  1. Run a query that returns the number of trouble tickets in the VTM024… table, but only the ones created in the year 2015. Note: when setting the where criteria, use a function to extract the Year portion from the timestamp field.
  2. Using the Year function in the first answer, write SQL that shows the number of trouble tickets created in each year dynamically, and do this using a “GROUP BY” clause in the SQL. It should return something like: 2012       10 2013       54 2014       111 etc
I found the answer to first query. Can someone help me with 2nd one?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    What is the specific problem you are facing?
    What have you tried?

    The instructions already mention that you need to use the GROUP BY clause, so, it shouldn't be too hard for you to do it.

    You should not "find" the answer. You should write it by yourself. Otherwise, you will not learn.
    84,310 pointsBadges:
    report
  • faizanahmad23
    Hey thanks.
    I was able to find the solution for it.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: