Author name: admin

SQL

SQL SELECT RANDOM

The SQL SELECT RANDOM() function returns the random row Synatx SELECT column FROM table ORDER BY RAND ( ) LIMIT […]

SQL

SQL SELECT LAST

SQL SELECT LAST : The last() function is used to return the last value of the specified column of a

SQL

SQL SELECT FIRST

SQL SELECT FIRST : The SQL first() function is used to return the first value of the selected column. Here

SQL

SQL SELECT TOP

The SQL SELECT TOP Statement is used to select top data from a table. SELECT TOP  2 *  FROM employee

SQL

SQL SELECT COUNT

SQL SELECT COUNT : The SQL COUNT() function is used to return the number of rows in a query. The COUNT() function

SQL

SQL SELECT DISTINCT

The SQL DISTINCT command is used with SELECT key word to retrieve only distinct or unique data. In a table, there may

SQL

SQL SELECT UNIQUE

SQL SELECT UNIQUE Actually, there is no difference between DISTINCT and UNIQUE. SELECT UNIQUE is an old syntax which was used

SQL

SQL SELECT Query

SQL SELECT Query is the most commonly used statement in SQL. The SELECT Statement in SQL is used to retrieve

SQL

MS Access Functions

MS Access Functions has many built-in functions. This reference contains the string, numeric, and date functions in MS Access. MS

SQL

SQL Server Functions

SQL Server has many built-in functions. SQL Server Functions This reference contains string, numeric, date, conversion, and some advanced functions

Scroll to Top