1. Exp() function : In MS Access, the Exp() function returns e( 2.718281) power raised to a number. In this function, a number will be… Read More
Tag Archives: DBMS-SQL
A table might have repetitive data in form of rows. This might cause glitches while retrieving data from the query. To avoid them, a unique… Read More
1. Union : Union means joining two or more data sets into a single set. In SQL Server, Union is used to combine two queries… Read More
We take a sample table named Geeks and return unique column values by applying various SQL queries on it. Table – Geeks G_ID FIRSTNAME LASTNAME… Read More
SQL MIN() Functions The MIN() function provides the smallest value of the chosen column. MIN() Syntax – SELECT MIN(column_name) FROM table_name WHERE condition; SQL MAX()… Read More
1. Structured Query Language (SQL) : SQL stands for Structured Query Language. SQL can access, created and manage databases. SQL has became standard of American… Read More
SQL COUNT() Function : The COUNT() function provides the number of rows that matches a specified condition. COUNT() Syntax – SELECT COUNT(column_name) FROM table_name WHERE… Read More
Window functions applies aggregate and ranking functions over a particular window (set of rows). OVER clause is used with window functions to define that window.… Read More
1. mSQL : Mini SQL, or mSQL, is a lightweight database engine designed to provide fast access to stored data with low memory requirements. As… Read More
A schema is a collection of database objects like tables, triggers, stored procedures, etc. A schema is connected with a user which is known as… Read More
1. Mid() function : In MS Access the mid() function will extract the string from a given position. In this function 3 parameters will be… Read More
Prerequisite – Introduction of MS SQL Server 1. Self Join : Self-join allows us to join a table itself. It is useful when a user… Read More
A database contains many tables that have data stored in order. To delete the rows, the user needs to use a delete statement. 1. To… Read More
We know that a database can different datatypes. Consider an organization having various databases like Employees, Departments, Finance. The employee database has a table that… Read More
1. Fix() Function : In MS Access, the fix() function returns the integer part of a number. In this function, a number will be pass… Read More
Courses
