select * from emp group by eno having sal > 5000

select EMPNO, EMPNAME, min(salary) AS SALARY from emp group by empno,empname having min(salary) > 5000

SELECT EmployeeNo, EmployeeName, MIN(Salary) AS Salary FROM EMPLOYEE
GROUP BY EmployeeNo, EmployeeName
HAVING MIN(Salary) > 5000

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question