Need a distinct result set
-
Hello, I have the below data stored in a temp table:
I need to get the distinct data to include last_name, first_name, Department, work_ext and ordered by access_time descending. I cannot have the access_time column in the result set. Is there a way to easily accomplish this using a CTE or some other method? Please provide a solution.
Thank you,
D -
You will learn a lot more by doing your own homework rather than getting others to do it for you.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA - oradbguru - Thursday, November 15, 2018 8:34 AMHello, I have the below data stored in a temp table:
I need to get the distinct data to include last_name, first_name, Department, work_ext and ordered by access_time descending. I cannot have the access_time column in the result set. Is there a way to easily accomplish this using a CTE or some other method? Please provide a solution.
Thank you,
DWith >2,000 points, you should know that we would need DDL, INSERT statements etc in order to provide a working solution.
Having said that, with >2,000 points you should also be able to write this in your sleep. What have you tried so far?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
You guys are absolutely right. Sorry, I was in a production crisis with another issue and I was looking for a lifeline to get this one off my plate. I have it now. Thank you!
David
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply