SQL Min() Function
The MIN function is use to return the smallest value of the selected column. MIN can be use only in numeric column.
As with other function, you can also give an Alias to the MIN function.
SQL MIN() Syntax
English Dictionary System
Simple Dictionary System which you search and add words. Hope you like it.
Student Information System
This Information System is for the begginers only. Features: Add Record, Update Record, Search Record and Delete Record. Try to understand the codes guy'z.. >
Simple ATM System
Last 2010 i made this system, this is a simple ATM System which you can deposit, widraw and view your account balance. This system is requested by the second year students. Feel free to use it guy'z. >
SQL SUM() Function
The SUM function is an aggregate function use to calculate the total amount of a column. SUM function can be use only in numeric column.
Syntax
Shopping Cart Application
Shopping Cart Application in C# for more information Call me on +919920049934 www.itprojectsworld.blogspot.com [email protected] or [email protected]
SQL NOW() Function
The NOW() function is an aggregate function used to return the date and time along with other column.
The NOW() function returns the result as dd/mm/yyyy HH:MM:SS AM/PM depending on your regional settings.
SQL NOW() Syntax
SQL LEN() Function
The LEN function is useful to count the number of characters in a column you specified as the parameter. LEN is short for length. The LEN function returns the number of characters including spaces or any character within that column.
You can use SQL Alias to name the result of the LEN function.
SQL LEN() Syntax
SQL FORMAT Function
The FORMAT() function is normally applied on formatting column with Date value like YYYY, MM, and DD.
SQL FORMAT() Syntax
SQL UNIQUE Contraints
The UNIQUE Contraints identifies a record in a database table uniquely. Unlike PRIMARY KEY contraints, you can have many UNIQUE contraint in a table.
UNIQUE Contraints Syntax - MySQL