Types of SQL Joins are explained in left, right, and full join and SQL | Join (Cartesian Join & Self Join). And Remaining EQUI Join… Read More
Tag Archives: DBMS-SQL
1. First() Function : In MS Access, the First() function is used to return a field value from the first record in the result set… Read More
In this article, we are going to cover VarType function in MS Access and will cover variable type of VarType function and also we will… Read More
1. QBColor() Function : QBColor() Function in MS Access is used to get the RGB color code .It returns a Long number representing the RGB color… Read More
The RANK() function is a window function could be used in SQL Server to calculate a rank for each row within a partition of a… Read More
1.DMin() Function : DMin() Function in MS Access is used to determine the minimum values in a specified set of records (a domain). The DMin… Read More
1. SLN() Function : SLN() Function in MS Access is used to calculate the straight-line depreciation of an asset for a single period. Syntax :… Read More
1. Hex() Function : Hex() Function in MS Access is used to returns a String representing the hexadecimal value of a number. Syntax : Hex(number)… Read More
1. DDB() Function : DDB() Function in MS Access is used to calculate the depreciation of an asset for a specific time period using the… Read More
1. StDev() Function : StDev() Function in MS Access is used to estimate the standard deviation for a population sample. Syntax : StDev (expr) Parameter… Read More
NTILE() function in SQL Server is a window function that distributes rows of an ordered partition into a pre-defined number of roughly equal groups. It… Read More
1. Second() Function : In MS Access, the second() function returns the second part of the datetime. In this function, the datetime will be passed… Read More
1. LCASE() : The LCASE() function used to convert a text to lower-case. This function is a similar to the LOWER() function. Syntax : SELECT… Read More
1. Date() Function : Date() function returns the current date of the system. In this function, no parameter will be passed and it will return… Read More
1. Day() Function : Day() function returns the day of the month for a given date. In this function, it will take a date as… Read More
