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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
-
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