SQL, Create Database and table, Data type, Select, Where, Order by, Limit

Author: Al-mamun Sarkar Date: 2020-04-18 10:03:08

আজকে আমার SQL কি, কিভাবে Database, and table টেবিল তৈরি করতে হয়, Data type, Select, Where, Order by, Limit নিয়ে আলোচনা করব। 

 

SELECT * FROM students;


SELECT id, name, age FROM students;


SELECT DISTINCT age FROM students;


SELECT * FROM students 
WHERE id = 1;


SELECT * FROM students 
WHERE name = 'Tamim';


SELECT * FROM students 
WHERE id <> 1;


SELECT * FROM students 
WHERE id > 2;


SELECT * FROM students 
WHERE id <= 2;


SELECT * FROM students
WHERE gpa IS NULL;

SELECT * FROM students
WHERE gpa IS NOT NULL;


SELECT * FROM students 
WHERE id BETWEEN 2 and 3;


SELECT * FROM students 
WHERE id IN (1, 4, 5);


SELECT * FROM students
WHERE name LIKE 'Ra%';


SELECT * FROM students
WHERE name LIKE '%im';


SELECT * FROM students
WHERE name LIKE '%mi%';



SELECT * FROM students
WHERE age = 21 AND id = 3;


SELECT * FROM students
WHERE age = 12 OR id = 3;


SELECT * FROM students
ORDER BY age;

SELECT * FROM students
ORDER BY age ASC; 

SELECT * FROM students
ORDER BY age DESC; 


SELECT * FROM students
LIMIT 0, 2;

SELECT * FROM students
LIMIT 2, 2;