1. SQL1 dept create table without primary key.
2. SQL2 data insertion into two ways.
4. SQL4 display column in a table.
5. SQL5.USE OF WHERE IN A TABLE.
6. SQL6 display data where location=mumbai.
7. SQL7 WHAT IS MAIN PROBLEM IF WE NOT USE ANY PRIMARY KEY IN A TABLE.
8. SQL8 DELETE THE TABLE DEPT.
9. SQL9 PRIMARY KEY CREATION IN TABLE.
11. SQL11 USE OF DESC IN SQL .
12. SQL12 USE OF DEFAULT VALUE IN SQL TABLE.
14. SQL14 WHY FOREIGN KEY IS USED??
15. SQL15 USE OF BETWEEN KEYWORD IN SQL.
16. SQL16 USE OF NOT BETWEEN IN SQL.
17. SQL17 CURRENT DATE USING SYSDATE IN SQL.
25. SQL25 STARTING AND ENDING WITH LETTER.
18. SQL18 DUAL TABLE IN SQL.
19.SQL19 ARITHMETIC OPERATION IN SQL USING DUAL TABLE.
20.SQL20 COLUMN RENAME USING AS IN SQL.
21. SQL21 STRING PATTERN MATCHING.
22. SQL22 ENDING WITH A LETTER. STRING PATTERN MATCHING.
23. SQL23 SATRTING WITH TWO LETTER।
24. SQL24 ENDING WITH TWO LETTER।
26. SQL26 SECOND LETTER MATCHING।
27. SQL27 3RD LETTER MATCHING।
28. SQL28 4 LENTH NAME OR 4 LENGTH STRING।
29. SQL29 SECOND LETTER AND 4TH LETTER CHECKING.
31. SQL31 matches a SUBSTRING
34. SQL34 NAME WITH TWO AA
35. SQL35 FUNCTION OF COUNT() , COUNT() এর কাজ।
36. SQL36 FUNCTION OF MAX(), MAX() এর কাজ।
37. SQL37 FUNCTION OF MIN(), MIN () এর কাজ।
39. SQL39 FUNCTION OF AVG(), AVG()এর কাজ।
42.SQL42 FUNCTION OF GROUP BY. GROUP BY এর কাজ।
40. SQL40 USE OF IN, IN এর কাজ।
41. SQL41 FUNCTION OF NOT IN, NOT IN এর কাজ।
No comments:
Post a Comment