Your question, your audience. Choose who sees your identity—and your question—with question security.
Last record chosen in Oracle Query
I need to only retrieve the last record when this Oracle 9.2 query executes.
DI 2016-09-26 168398 063848979 //SRC RMS
I would also like another Oracle query that only retrieves the first record.
NULL DI 2016-09-16 174261 063848979 //SRC RMS FB BRAMPTON TO
Right now, the query will retrieve 3 records for this problem when it executes.
The 1993237 will be a field once I get it to work.
This Oracle query executes inside a SQL query.
SELECT (CASE WHEN TO_CHAR(aa.NOTES) IS NOT NULL THEN TO_CHAR(aa.NOTES) ELSE TO_CHAR(a.PTEXT) END) as MyNote
FROM GPCOMP1.GPPROB a, GPCOMP1.GPPROBNOTES aa
WHERE a.PROBLEM_ID = aa.PROB_ID AND (a.PROBLEM_ID = 1993237)
ORDER BY a.MODIFIED_ON DESC
DI 2016-09-26 168398 063848979 //SRC RMS
I would also like another Oracle query that only retrieves the first record.
NULL DI 2016-09-16 174261 063848979 //SRC RMS FB BRAMPTON TO
Right now, the query will retrieve 3 records for this problem when it executes.
The 1993237 will be a field once I get it to work.
This Oracle query executes inside a SQL query.
SELECT (CASE WHEN TO_CHAR(aa.NOTES) IS NOT NULL THEN TO_CHAR(aa.NOTES) ELSE TO_CHAR(a.PTEXT) END) as MyNote
FROM GPCOMP1.GPPROB a, GPCOMP1.GPPROBNOTES aa
WHERE a.PROBLEM_ID = aa.PROB_ID AND (a.PROBLEM_ID = 1993237)
ORDER BY a.MODIFIED_ON DESC
Asked:
2
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
select mynote from (
SELECT (CASE WHEN TO_CHAR(aa.NOTES) IS NOT NULL THEN TO_CHAR(aa.NOTES) ELSE TO_CHAR(a.PTEXT) END) as MyNote,
row_number() over(order by modified_on asc) rn
FROM GPCOMP1.GPPROB a, GPCOMP1.GPPROBNOTES aa
WHERE a.PROBLEM_ID = aa.PROB_ID AND (a.PROBLEM_ID = 1993237)
)
where rn=1
Last row:
select mynote from (
SELECT (CASE WHEN TO_CHAR(aa.NOTES) IS NOT NULL THEN TO_CHAR(aa.NOTES) ELSE TO_CHAR(a.PTEXT) END) as MyNote,
row_number() over(order by modified_on desc) rn
FROM GPCOMP1.GPPROB a, GPCOMP1.GPPROBNOTES aa
WHERE a.PROBLEM_ID = aa.PROB_ID AND (a.PROBLEM_ID = 1993237)
)
where rn=1
I'm guessing that really isn't what you want. Can you provide some sample data and exepected results?