Oracle sql id count [message #658878] |
Thu, 29 December 2016 08:21 |
|
Aleks21
Messages: 1 Registered: December 2016
|
Junior Member |
|
|
In my table there are rows
Example table
ID, Employee
01, Employee1
02, Employee1
03, Employee1
04, Employee2
05, Employee2
06, Employee2
07, Employee3
08, Employee3
After work of my sql request it shows more rows than it should be.
Perhaps the error at zero. How shoud I fix my sql request?
Result table:
Employee,ID
Employee1,3
Employee2,3
Employee3,2
-
Attachment: sql.txt
(Size: 3.26KB, Downloaded 1430 times)
|
|
|
|
|
Re: Oracle sql id count [message #658886 is a reply to message #658878] |
Thu, 29 December 2016 09:26 |
|
Michel Cadot
Messages: 68648 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
Also always post your Oracle version, with 4 decimals, as solution depends on it.
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
|
|
|