THE PATH TO SUCCESS IN EXAM...
Unit 1: Database Concepts | Basics of RDBMS Important Question Answer 1. What is the full form of DBMS? Answer: Database Management System 2. What is Data? Answer: Data is a collection of raw facts which have not been processed to reveal useful information. 3. What is Information? Explain with the help of diagram and […]
Class 12 IT 802 Unit 1 : Database Concepts – Basics of RDBMS Question Answer Read More »
SQL Functions – Single Row and Aggregate Group By , Having clause Joins in SQL Functions in SQL Function is used to perform some particular task and it returns zero or more values as a result. Functions can be applied to work on single or multiple records (rows) of a table. Depending on their application
SQL Functions , Grouping Records, Joins in SQL – Notes Read More »
Topics Covered: Functions – Introduction MySQL Single Row Functions Mathematical Functions String / Text Functions Date & Tiime Functions MySQL Aggregate Functions AVG() COUNT() MAX() MIN() SUM() . Functions – Introduction My SQL function performs a pre-defined task and returns a single value such as a numerical, string, or date/time value. Functions operate on zero,
Database Querying using SQL – Functions, Join and Set Operation Read More »
You cannot copy content of this page
