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 ReesYou can lead a horse to water, but a pencil must be lead.
Stan Laurel -
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