| CREATE TABLE employee( LName varchar(255), FName varchar(255), City varchar(255), Age INT, Salary INT);
|
| Expand Requery Edit Explain Profiling Database : lab2 Queried time : 8:27:2
|
| SELECT * FROM `employee`
|
| INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Rubayad','Hasan','Noahkhali',55,250);
|
| SELECT * FROM `employee`
|
| INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Rummon','Dhaka',60,5000);
|
| SELECT * FROM `employee`
|
| SELECT * FROM `employee`;
|
| INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Ruman','Dhaka',60,50000);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| INSERT INTO employee(LName,FName,City,Age,Salary)
|
| VALUES('Hasan','Rummon','Dhaka',60,5000);
|
|
|
|
|
|
|
| CREATE TABLE employee( LName varchar(255), FName varchar(255), City varchar(255), Age INT, Salary INT);
|
| SELECT * FROM `employee`
|
| INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Rubayad','Hasan','Noahkhali',55,250);
|
| SELECT * FROM `employee`
|
| INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Rummon','Dhaka',60,5000);
|
| SELECT * FROM `employee`
|
| SELECT * FROM `employee`;
|
| INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Ruman','Dhaka',60,50000);
|
| SELECT * FROM employee;
|
| Expand Requery Edit Database : lab2 Queried time : 8:43:13
|
| INSERT INTO employee(LName,FName,City,Age,Salary) VALUES ('Karp','Rabin','Dhaka',60,50000),('Sabbir','Johnny','Dhaka',65,1000);
|
| SELECT * FROM `employee`
|
| SELECT * FROM `employee`
|
| SELECT * FROM `employee`
|
| SELECT * FROM `employee`
|
| SELECT DISTINCT City FROM employee;
|
| SELECT Age,Salary FROM employee WHERE LName='Rummon';
|
| SELECT Age,Salary FROM employee WHERE LName='Rabiul';
|
| SELECT * FROM employee WHERE Age < 60;
|
| SELECT * FROM employee ORDER BY LName DESC;
|
| SELECT * FROM employee WHERE City='Dhaka' AND Salary > 500;
|
| SELECT * FROM employee WHERE City = 'Noahkhali' AND (LName LIKE 'R%' OR LName LIKE 'Ru%');
|
| SELECT * FROM employee WHERE NOT City = 'Noahkhali';
|
| SELECT * FROM employee;
|
| SELECT * FROM employee WHERE LName NOT LIKE 'R%';
|
| SELECT * FROM employee WHERE Salary BETWEEN 250 AND 5000;
|
| SELECT * FROM employee WHERE Age BETWEEN 60 AND 61;
|
| SELECT * FROM employee WHERE Salary NOT BETWEEN 10 AND 5000;
|
| SELECT * FROM employee WHERE NOT Salary > 5000;
|
| SELECT * FROM employee WHERE NOT Salary < 5000;
|
| SELECT * FROM employee WHERE NOT Age < 65;
|
| SELECT * FROM employee WHERE City IN ('Noahkhali');
|
| SELECT * FROM employee WHERE City IN ('Noahkhali');
|
| SELECT * FROM employee WHERE City IN ('Noahkhali','Dhaka');
|
| SELECT * FROM employee WHERE LName IN ('Rubayad');
|
| SELECT * FROM employee WHERE LName NOT IN ('Rubayad');
|