Orable Turn two separate queries into a single row
Hi
Is it possible to take the following two queries and turn them in to one single row as a result?
SELECT COUNT(UNIT) AS RECEIVEDTODAY
FROM UNIT_KILOMETRAGE_HISTORY_V
WHERE LINE = 'TestOne' AND TRUNC(DATERECEIVED) = SYSDATE
This might yield a number such as 6
SELECT COUNT(UNIT) AS PAST5DAYS
FROM UNIT_KILOMETRAGE_HISTORY_V
WHERE LINE = 'TestOne' AND TRUNC(DATERECEIVED) = SYSDATE - 4
This might yield a different number such as 15
Is it possible to take the following two queries and turn them in to one single row as a result?
SELECT COUNT(UNIT) AS RECEIVEDTODAY
FROM UNIT_KILOMETRAGE_HISTORY_V
WHERE LINE = 'TestOne' AND TRUNC(DATERECEIVED) = SYSDATE
This might yield a number such as 6
SELECT COUNT(UNIT) AS PAST5DAYS
FROM UNIT_KILOMETRAGE_HISTORY_V
WHERE LINE = 'TestOne' AND TRUNC(DATERECEIVED) = SYSDATE - 4
This might yield a different number such as 15
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER