CLASS TEST FOR CLASS XII C&D
Link for class test start from here 1. SELECT DATE ( '2004-12-21 01:02:03' ); 2. SELECT DATE ( '2008-05-17 11:31:31' ) as required_DATE ; '20 3. SELECT MONTHNAME('2009-05-18'); 4. SELECT ROUND ( 4.43 ); SELECT POW(3, 2); 5. SELECT MOD ( 17 , 5 ); 6. SELECT ABS ( - 5 ); 7. SELECT INSTR ( 'myteststring' , 'st' ); 8. SELECT SUBSTR ( 'w3resource' , 4 , 3 ); 9. SELECT RIGHT ( 'w3resource' , 8 ); 04-12-21 01:02:03'); Explain these question What is single line and multiple line function? What is difference between where and having clause? What is Aggregate function ? explain with suitable example ?