Home » SQL & PL/SQL » SQL & PL/SQL » distinct *
distinct * [message #194186] Thu, 21 September 2006 02:28 Go to next message
webadministrator
Messages: 45
Registered: October 2005
Member
hello,
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
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Just use
SELECT DISTINCT * 
FROM   employees;
Previous Topic: Union and then OrderBy
Next Topic: give parameters into function
Goto Forum:
  


Current Time: Wed Dec 07 18:31:48 CST 2016

Total time taken to generate the page: 0.04997 seconds