9 - Having Clause(To put condition on count)

 

ORIGINAL TABLE GENERATED




Filter the Maximum Salary for department  whose count is 2 or more than 2


select *from employees where salary in(select max(salary) from employees group by department having count(department)>=2) ;


Filter the Minimum Salary for department  whose count is 2 or more than 2


select *from employees where salary in(select min(salary) from employees group by department having count(department)>=2) ;


Comments

Post a Comment

Popular posts from this blog

8 - Filtering Max or Minimum Salary from each Department(Group By)

Image
  ORIGINAL LIST Filter the Maximum Salary and Its details from Each Department select * from employees where salary in ( select max (salary) from employees group by department); Filter the  Minimum Salary and Its details from Each Department select * from employees where salary in ( select min (salary) from employees group by department);
Read more

INDEX OF Zeek MySQL

Spring Blog Index Page Basic Concepts of SQL (1-3) OPEN/CLOSE No Title Labels 1 Data, DataBase, DataModel Types & Infrastructure Infrastructure for DATA MODEL Types Of Data Models What is data and database? 2 Concepts of DBMS,RDBMS ,SQL and DBMS vs RDBMS DBMS vs RDBMS RDBMS and its features and SQL features What is DBMS its benefits 3 SQL Starting(Introduction, Data-Types,Constraints and Command-Groups) SQL Data Types SQL Constraints SQL |...
Read more

6 - Filtering Data by using (where , and , or , ! , > , <)

Image
  ORIGINAL TABLE GENERATED List from which we filter Data  data from table where emp_id has value 2 select * from employees where emp_id= 2 ; data from table where value of salary is 900 select * from employees where salary= 900 ; data from table where first_name is Tom as well as salary is 900 select * from employees where first_name= 'Tom' and salary= 900 ; data from table where either the last_name is Khan or salary is 8000 select * from employees where last_name= 'Khan' or salary= 8000 ; data from table where either the last_name is Khan or salary is greater than 80000 select * from employees where last_name= 'Khan' or salary> 80000 ; data from table where the last_name is Khan as well as salary is greater than 80000 select * from employees where last_name= 'Khan' and salary> 80000 ; data from table where either last_name is Geller or salary is not equal to 50000 select * from employees where last_name= 'Geller' o...
Read more