Home » SQL & PL/SQL » SQL & PL/SQL » distinct *
distinct * [message #194186] Thu, 21 September 2006 02:28 Go to next message
Messages: 45
Registered: October 2005
i have a table where i want to select all the distinct records im putting the following query but its not working:
select distinct * from employees group by employee_number (employee_number is not the primary key)

plz can u help
Re: distinct * [message #194194 is a reply to message #194186] Thu, 21 September 2006 02:45 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Just use
FROM   employees;
Previous Topic: Union and then OrderBy
Next Topic: Trigger and event code.
Goto Forum:

Current Time: Sat Aug 19 19:37:48 CDT 2017

Total time taken to generate the page: 0.32507 seconds