Database Basic Query for Beginner | Learn MySQL | Using PgAdmin

select * from employees;

Select * from employees where firstname='Rohit';

Select * from employees where firstname like '_o%';

select * from employees order by city asc;

select * from employees limit 2;


CREATE TABLE Persons (
    ID int NOT NULL UNIQUE,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);

select * from Persons;

INSERT INTO persons (ID, LastName, FirstName, Age)
VALUES (6,null, 'Rohit', 34);

INSERT INTO persons (ID, LastName, FirstName, Age)
VALUES (6,'Sahoo', 'Rohit', 34);

update Persons set lastname='Sahoo' where id=5;

UPDATE Persons
SET lastname='Soni' where id='6';

select firstname ||' '|| lastname as Name from persons order by id limit 2;

select SUM(age) from persons;

select count(age) from persons where age=34;

select round(AVG (age)) from persons;

select MIN(age) from persons;

select MAX(age) from persons;

SELECT DISTINCT age FROM persons;

UPDATE persons SET age = age*1.2
where firstname like 'Ro%';

select * from employees;
select * from persons;

SELECT employees.firstname, employees.lastname
FROM employees
INNER JOIN persons
ON persons.lastname = employees.lastname;