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

5 - DML commands used in MySQL WorkBench

Image
DML(Data Manipulation Language)  CREATING A TABLE create table employees( emp_id int not null , first_name varchar ( 20 ) not null , last_name varchar ( 10 ), salary int , primary key (emp_id) ); INSERTING DATA IN TABLE insert into employees(emp_id,first_name,last_name,salary) values ( 1 , 'Zeeshan' , 'Khan' , 50000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 2 , 'Ross' , 'Geller' , 60000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 3 , 'Rachel' , 'Green' , 8000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 4 , 'Joey' , 'Tribbiani' , 99000 ); select * from employees; UPDATING OR CHANGING DATA update employees set last_name= 'Geller' where emp_id= 3 ; select * from employees; DELETING DATA  delete from employees where emp_id= 4 ; select * from employees; OUTPUT GENERATED
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

4 - DDL commands used in MySQL Workbench

Image
  I have done following things on MySQL workbench using DDL commands-- 1- Create a table name employee with emp_id , first_name , last_name , salary. 2-Add a column contact. 3- Rename the column contact to job_code. 4-Deleting the table   Create a table name employee with emp_id , first_name , last_name , salary. Table Generated looks like Logical structure of table Add a column contact. Seeing the new table Renaming column contact to job_code Seeing the table Deleting the table
Read more