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

Report message to a moderator

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;

Report message to a moderator

Previous Topic: Union and then OrderBy
Next Topic: give parameters into function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 14 14:17:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.