Having following table named RATING :EmpID,ReviewSeason,CustID1,s1,c11,s1,c21,s2,c32,s2,c22,s3,c43,s3,c5Write a SQL statement, return EmpID who has been REVIEWED more than once.

Questions by zanhsieh   answers by zanhsieh

Showing Answers 1 - 3 of 3 Answers

Harshita

  • Apr 18th, 2006
 

select empID from RATING group by ReviewSeason having count(empID)>1

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions