Last post Mar 16, 2020 07:05 AM by yij sun
Mar 13, 2020 08:23 AM|Magesh.L|LINK
I need to find the result same experience with different level using SQL
Mar 13, 2020 08:59 AM|Prathamesh Shende|LINK
what do you want to acheive please ellaborate ?
Mar 13, 2020 09:10 AM|Magesh.L|LINK
I need same experience with different level
For e.g Emp.No.1 and Emp.No.2 has same experience but different level
Mar 16, 2020 07:05 AM|yij sun|LINK
Accroding to your description,I don't understand your reuqirment clearly.
What do you want to output?Could you post the output sample about your requirment.
Since you don't post more details about samples, I create a demo to group by Exp and use having count the level >1.
More details, you could refer to below codes:
select Emp.ENo,Emp.EName,Emp.EExp,Emp.ELevel,Emp.ESalary from Emp inner join(select EExp from Emp group by EExp HAVING COUNT(distinct ELevel) > 1) dup
ON dup.EExp = Emp.EExp