What are the different type of SQL's statements ?

Question

basics sql statement

Answer 1

Hi Sanjay. Depends on...For example, in Microsoft SQL we use LIMIT, in Oracle ROWNUM:

SELECT * FROM TABLE LIMIT 3;
SELECT * FROM TABLE WHERE ROWNUM <=3;

Answer 2

DDL,DML,DCL

Answer 3

data definition language( create , alter ,drop , truncate)
data manipulation language(select,update,delete,insert)
data control language(grant,revoke,rolback,,commit,set)