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!

  • Congratulations Mike Lewis 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. excelcus

    SQL Query Help

    ok great. Thanks a lot Carp.
  2. excelcus

    SQL Query Help

    SELECT Table1."Customer ID", CONCAT(CONCAT(CONCAT('FY ',Table1."Period1"), ' to FY '), Table2."Period1") AS "YEAR_PERIOD", ROUND(((Table1."SALES" - Table2."SALES")/Table2."SALES") * 100, 2) AS "PERCENT", Table1."NEW COLUMN" FROM (SELECT "Customer ID", TO_NUMBER(SUBSTR("Period1", 3, 4))...
  3. excelcus

    SQL Query Help

    Hi! I have a derived table in which there is an outer select statement and in FROM clause I have 2 more selects. I need to add a colum to outer select based on table in FROM clause. Now the other queries seemed pretty simple but here is the issue with this one. On DB level the table from which I...

Part and Inventory Search

Back
Top