Rahul Thosar

  Indentity columns :- It Increases the  data value automatically .   TABLE CREATION QUERY :- CREATE   TABLE  DEMO1   ( ID INT   IDENTITY ( 1 , 1 )   ,   NAME   VARCHAR ( 50 )   ); INSERT   INTO  DEMO1   ( NAME )   VALUES ( 'BABUBHAIYA' ); INSERT   INTO  DEMO1 ( NAME )   VALUES ( 'RAJU' ); INSERT   INTO  DEMO1 ( NAME )   VALUES ( 'SHAM' ); SELECT   *   FROM  DEMO1 ; Q.  HOW TO RESET THE IDENTITY TABLE USING TRUNCATE ? ANS - SYNTAX :- TRUNCATE TABLE TABLENAME; EX :- INSERT   INTO  DEMO1   ( NAME )   VALUES ( 'BABU BHAIYA' ),( 'RAJU' ),( 'SHAM' ); SELECT   *   FROM  DEMO1   l  HOW TO CREATE NOT NULL COLUMN? EX:- CREATE   TABLE  DEMO2 ( ID INT   NOT   NULL,   NAME   VARCHAR ( 50 )) INSERT   INTO  DEMO2 VALUES ( 1 , 'SALMAN KHAN ' ),( 2 ,   'ASHWARIYA RAI' ),( 3 , 'KATRINA KAF ' ...

   Day - 41 (27-03-2025)   l  Half day due to college placement .    Day - 42 (27-03-2025)   l  BETWEEN CLAUSE:- It display range data value Q.  Display student records between 102-104. Ans.   SELECT   *   FROM  Student WHERE   roll BETWEEN  101 AND  204 ;   l    ORDERBY CLAUSE:- 1.  ASSCENDING ORDER:-  SYNTAX= ASC   2.  DESSCENDING ORDER :-SYNT= DESC EX:- SELECT   *   FROM  Student   ORDER   BY  roll DESC ;       l   GROUP BY CLAUSE :- It is used to display similarly records at onces. Ex :- SELECT   name   FROM  Student GROUP   BY   name   ; l   In clause :- It is used to scearch mutliple data . Ex. SELECT   *   FROM  Student WHERE   name   IN   ( 'Riddhima' , 'tuktuk' );     l  Delete queries :- The delete query cannot used ...

Day 40 (26-03-2025)   u  Insert Queries    Method :- I.  Insert All record II.  Insert particular column III.  Inliner Insert   1.  Insert All record :- Syntax:- INSERT INTO TABLENAME VALUE(RECORD)   EX- INSERT   INTO  EMP VALUES ( 101 , 'SWARUP' ); INSERT   INTO  EMP VALUES ( 102 , 'rahul' ); INSERT   INTO  EMP VALUES ( 103 , 'Somesh' ); INSERT   INTO  EMP VALUES ( 104 , 'yash' ); INSERT   INTO  EMP VALUES ( 105 , 'anand' );   INSERT INTO PARTICULAR COLUMNS SYNTAX:-   INSERT INTO TABLENAME(COL NAME)VALUES(RECORD);   Ex. INSERT   INTO   Student   ( NAME )   VALUES ( 'SANTA ' );           l  Inline Insert   :- Insert mutilple record in a single line   Syntax:- INSERT INTO TABLENAME VALUES(RECORD),(RECORD),------------   EX- INSERT   INTO  student VALUES ( 202 , 'Riddhima' ),( 201 , 'tuktuk' ...