ช่วยหา ความหมายพร้อมผลลัพให้หน่อย ย ยย !!

1. SELECT * FROM users; แสดงทุกเรคคอร์ดในแฟ้ม users
2. SELECT id,name_emp FROM users;
3. SELECT salary,name_emp,id FROM users;
4. SELECT * FROM goods WHERE code=3;
5. SELECT code,name FROM goods WHERE cost>13000;
6. SELECT * FROM goods WHERE cost < 1000;
7. SELECT code,name,cost FROM goods WHERE amount >= 15;
8. SELECT name,amount,ismin FROM goods WHERE amount <= ismin;
9. SELECT * FROM users WHERE start_date='2010-06-01';
10. SELECT * FROM users WHERE salary > 10000 AND salary <= 14000;
11. SELECT * FROM users WHERE salary BETWEEN 10000 AND 14000;
12. SELECT * FROM users WHERE start_date='2010-02-10';
13. SELECT * FROM users WHERE start_date >= '2009-02-10' AND start_date <= '2009-12-30';
14. SELECT * FROM users WHERE division_id<>1;
15. SELECT * FROM users WHERE substring(start_date,9,2)= '10';
16. SELECT * FROM users WHERE substring(start_date,6,2)= '06';
17. SELECT * FROM users WHERE division_id=2 OR division_id=3;
18. SELECT * FROM goods WHERE name LIKE '%dy%' ;
19. SELECT * FROM users WHERE name_emp LIKE '%ดี';
20. SELECT * FROM users WHERE start_date LIKE '2010%';
21. SELECT DISTINCT(division_id) FROM users;
22. SELECT MAX(salary) FROM users;
23. SELECT MIN(salary) FROM users;
24. SELECT sum(amount) FROM goods;
25. SELECT count(name) FROM goods where kind='1';
26. SELECT * FROM goods ORDER BY cost;
27. SELECT * FROM goods ORDER BY amount ASC;
28. SELECT * FROM goods ORDER BY amount DESC;
29. SELECT id,name_emp,salary FROM users ORDER BY salary;
30. SELECT name_emp,salary,start_date FROM users ORDER BY salary ASC;
31. SELECT name,kind,cost,amount FROM goods ORDER BY kind,cost;
32. SELECT name,cost,amount,kind FROM goods ORDER BY cost,kind;
33. SELECT name,cost,amount,kind FROM goods ORDER BY cost DESC,kind;
34. SELECT name_emp,salary,start_date FROM users ORDER BY salary DESC,start_date DESC;
35. SELECT * FROM users WHERE division_id=2 ORDER BY salary;
36. SELECT * FROM users WHERE division_id=2 or division_id=3 ORDER BY division_id,salary DESC;
37. SELECT kind,sum(amount) FROM goods GROUP BY kind;
38. SELECT kind,sum(amount) as abc FROM goods GROUP BY kind HAVING abc>60;
39. SELECT division_id,sum(salary) FROM users GROUP BY division_id;
40. SELECT division_id,sum(salary) as abc FROM users GROUP BY division_id;
41. SELECT division_id,sum(salary) as abc FROM users GROUP BY division_id HAVING abc>20000;
42. SELECT division_id,sum(salary) as xyz FROM users GROUP BY division_id ORDER BY xyz DESC;
43. SELECT division_id,sum(salary) as xyz FROM users GROUP BY division_id HAVING xyz>20000 ORDER
BY xyz DESC;
44. SELECT coss FROM goods;
45. SELECT * FORM goods;
46. SELECT DISTINCT(kind),SUM(cost) FROM goods GROUP BY kind;
47. SELECT DISTINCT(kind),SUM(cost) as total FROM goods GROUP BY kind ORDER BY total DESC;