MySQL Practice Sheet 1 (Maths Function)
MySQL Maths Functions
Revision of database concepts and SQL commands covered in class XI Scalar Functions - Numeric functions: POWER (), ROUND (), MOD (). String / Text functions: UCASE ()/ UPPER (), LCASE ()/ LOWER (), MID ()/ SUBSTRING () /SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME () Aggregate Functions - MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*). Querying and manipulating data using Group by, Having, Order by. Working with two tables using equi-join Querying & SQL ( Continue ) Syntax – pre-defined set of rules which tell how to write a command / statement for error free execution. (Every language has its own library where all the keywords – statements / functions / methods / attributes / modules are pre-defined with their structure(syntax). So during the translation phase (execution) the translator (assemble...
Comments
Post a Comment