Swetha Reddy

• Jul 18th, 2006

 

Try this:

select * from emp group by eno having sal > 5000

I have used eno incase ename is the same for one or more employees.

Pankaj Rastogi

• Jul 23rd, 2006

 

I think

Select Ename from EMP where Sal > 5000

Is the correct query. Because we don't have to access the number of the records. The above query will show all the employees' name who have salary more then 5000.

No need to make group by and having caluse.

Ashok

• Jul 27th, 2006

 

Hi Pankaj

Just read the Question once.

G.Ashok

umaGold

• Aug 1st, 2006

 

select ename from employee where salary > 5000

Raj Sekhar

• Aug 17th, 2006

 

In Sql Server try this

select max(empname) "EName",empid,salary from emp_temp group by empid,salary having salary > 5000

Saravanan

• Sep 14th, 2006

 

select emp_name,salary from employee group by emp_name,salary having salary>5000

sudhirbaranwal

 Profile Answers by sudhirbaranwal 

• Sep 23rd, 2006

 

Hi Uma,

Plz go through the question once again.

neerak

 Profile Answers by neerak Questions by neerak

• Oct 15th, 2006

 

Code
SELECT ENAME,SALARY FROM EMPLOYEES GROUP BY ENAME,SALARY HAVING SALARY>5000;

Hi, If you don't want to use where clause to get the employee names who are getting salary higher than 5000, you can use having clause.

Vinay Singh

• Dec 29th, 2006

 

SELECT ENAME,SAL FROM Emp
having sal>2000
group by empno,ename,SAL;

psonewane

 Profile Answers by psonewane 

• Apr 12th, 2007

 

Wrong sql statement

Parished.D Chennai India

• Apr 24th, 2007

 

create table ee (eno int, ename varchar(200), sal int)

insert into ee values(1, 'a', 2000)
insert into ee values(2, 'b', 6000)
insert into ee values(3, 'c', 8000)

select ENO, ENAME, min(sal) AS SAL from ee group by eno,ename having min(sal) > 5000

snktheone

• Aug 3rd, 2007

 

Try using good old self joins.

SELECT e.empname , e.salary FROM employee e INNER JOIN employee m ON E.EMPID
= M.EMPID AND E.SALARY >5000

Cheers!
Snktheone

nirajkvinit

 Profile Answers by nirajkvinit 

• Dec 17th, 2008

 

I don't understand why you are using the group by clause. There is no need. The question is very simple. It is already hinting of using having clause.

r

• Feb 21st, 2012

 

Using Group By

Code
FROM Employees


GROUP BY eid,ename,salary


HAVING salary>15000

Pushpa

• May 3rd, 2012

 

If we want to check any values to retrieve the data,case is the best.Case statement is simple and easy to understand.

Code
SELECT case when sal>1000 then ename end


FROM emp

Venkat Rahul

• Jun 5th, 2012

 

select ename from emp group by ename,sal having sal>5000;

SHRIRAM SHARMA

• Sep 9th, 2015

 

SELECT ED.First_Name, ED.Salary,
CASE
WHEN ED.Salary > 5000 THEN GREATER THEN 5000
ELSE NOT GREATER THEN 5000
END AS SALARY
FROM dbo.EmpolyeeDeatils ED

Chaitali

• Sep 29th, 2015

 

SELECT ENO, ENAME, SAL FROM EE GROUP BY ENO, ENAME, SAL HAVING SALARY > 5000

virendra kumar mishra

• Jan 6th, 2016

 

Use join

Code
SELECT ED.empname, ED.Salary,


CASE


WHEN ED.Salary > 5000 THEN 1 


END AS SAL


FROM dbo.employee ED 


INNER JOIN employee e ON ed.empid =e.empid AND CASE


WHEN ED.Salary > 5000 THEN 1 


END  IS NOT NULL

Shakeer

• Nov 2nd, 2016

 

Just presenting one more way is
;with cte as(
Select case when sal>5000 Then Name Else Null end as Name from Employee
)
Select * From Cte where Name is not null

Elan

• Jun 28th, 2017

 

Select Name,Sum(Salary) Salary From Employee Group By Name Having Sum(Salary) >=5000

dinesh chandra gannavarapu

• Apr 15th, 2020

 

SELECT EmpId,EmpName,Salary
FROM Employee
GROUP BY EmpId,EmpName,Salary
HAVING Salary>5000

Arshad

• Jul 29th, 2023

 

SELECT ENO, SUM(SALARY)
FROM EE
GROUP BY ENO
HAVING SUM(SALARY) > 5000