Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Darrel77

    Help with Group By....

    Mufasa... That seems to be the base of what I'm looking for! Worked like a charm. I'm gonna tweak the query a bit to look for a select number of accounts within a particular period, but in essence, I think I'm in good shape now. Thanks! Darrel
  2. Darrel77

    Help with Group By....

    Bill... I tried your sugesstion and I received a missing right parenthesis error on the "max(checknum) maxc" field. When I try to run the virtual table query by itself, I get a SQL command not properly ended on the same field. ------ Mufasa... In essence, if I have a TRANS table that reads...
  3. Darrel77

    Help with Group By....

    Here's what I need... My simple query looks like this.... SELECT acctnum, checknum, postdate, amt FROM trans WHERE checknum is not null AND postdate between '30-JAN-06' AND '02-FEB-06' GROUP BY acctnum, checknum, postdate, amt ORDER BY acctnum, checknum ...I need to create a report that...
  4. Darrel77

    Need to identify break in

    ca8msm... Thanks for the quick response....but I get the same error.
  5. Darrel77

    Need to identify break in

    Sorry about that....I'll repost in the Oracle forum
  6. Darrel77

    Need to identify break in

    SQLSister... I tried your post, but I get an error saying... "ORA-00934: group function is not allowed here" Please advise. Thanks, Darrel
  7. Darrel77

    Need to identify break in

    Here's what I need... My simple query looks like this.... SELECT acctnum, checknum, postdate, amt FROM trans WHERE checknum is not null AND postdate between '30-JAN-06' AND '02-FEB-06' GROUP BY acctnum, checknum, postdate, amt ORDER BY acctnum, checknum ...I need to create a report that...
  8. Darrel77

    HELP - Passing second value into separate column

    Hello all... I'm have a slight dilemma in SQL. I'm running the below query... select DISTINCT a.acct, p.first||' '||p.last OWNER, p2.first||' '||p2.last OWNER2 from person p, person p2, act a, actperson arp where a.NBR = p.nbr and arp.nbr = p2.nbr and a.acct = arp.acct ACCT OWNER...
  9. Darrel77

    Using value from one field to obtain additional returned rows in query

    Thanks..... I had this INNER JOIN code setup but somehow switched my final two aliases. - Darrel
  10. Darrel77

    Using value from one field to obtain additional returned rows in query

    Please pardon the long subject, but I have no idea how to explain this issue. Has anyone out there ever tried this one... I have a simple query that I need to complicate. This hopefully can be done. Take a look at the below sample data... select * from TABLE_A where nbr = '1234'; NBR REC TYPE...
  11. Darrel77

    Resetting Line Number field - HELP!!!

    Thanks to you both. I decided to go with swampBoogie's tip. It worked like a charm. Thanks again. - Darrel
  12. Darrel77

    Resetting Line Number field - HELP!!!

    I'm having a severe brain-freeze here, guys. Here's my dilemma: I have over 350 rows in my ADDRESS table in which a dataload has gone wrong. Over 350 rows were inserted into the ADDLINE table with no respect for the LINENBR value. And as we all know, if the line numbers aren't set to 1 and 2...

Part and Inventory Search

Back
Top