Search results for query: *

I am trying to query a table and find tickets that are open between 5 -30 days, 31-60 days & 61-90 days. I want all 3 queries in one report and I would like them totaled at the bottom. My query so far is select tabletwo.ticket "Ticket ", tabletwo.datecreated "Date &quot...

I am VERY new at Oracle and have not yet been at any classes except SQL/SQL Plus & PL/SQL so please bear with me. ( I did not build the database or tables and unfortunately no one that still works here did, so all the documentation is not there.) I am looking for a field in a table. Is there...

I am a newbie that needs help. (I also posted this to the Oracle Reports, hoping I would get an answer somewhere) I have a table that contains customer telephone numbers (the telephone number is in 2 separate fields)and also a customer ticket #. I want to retrieve all the duplicates (and only...

I am a newbie that needs help. I have a table that contains customer telephone numbers (the telephone number is in 2 separate fields)and also a customer ticket #. I want to retrieve all the duplicates (and only the duplicates) of those telephone numbers by ticket #. My output should look like...

I am a newbie and I see several posts for dups but none that seem to work for my tables. I have a table that contains customer telephone numbers (the telephone number is in 2 separate fields)and also a customer ticket #. I want to retrieve all the duplicates of those telephone numbers by ticket...