10 - Arranging or Sorting the table in Ascending or Descending order(Order by)

 

ORIGINAL TABLE GENERATED




Arrange or Sort the table in Ascending  order

select*from employees  order by  salary asc;





Arrange or Sort the table in  Descending order

select*from employees  order by  salary desc;



Comments

Post a Comment

Popular posts from this blog

12 - Combining Two Tables- JOIN ( Inner , Left and Right)

Image
  What is join in SQL database? SQL JOIN is a clause that is used to combine multiple tables and retrieve data based on a common field in relational databases TABLES WITH NAME employees AND department_location WITH ONE COMMON COLUMN NAME department employees department_location INNER JOIN The INNER JOIN keyword selects records that have matching values in both tables. select e.first_name,e.salary,d.department,d.location from employees e inner join department_location d on e.department=d.department; LEFT JOIN The LEFT JOIN keyword returns all records from the left table  (table1), and the matching records from the right table (table2).  The result is 0 records from the right side, if there is no match select e.first_name,e.salary,d.department,d.location from employees e left join department_location d on e.department=d.department; RIGHT JOIN The RIGHT JOIN keyword returns all records from the right table (table2), and the matching records from the left table (ta...
Read more

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

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