In this post we will learn how to calculate age from date of birth in sql. We can calculate...
LAST ARTICLES
Sql Query Birth Date Next Week
TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK Example 3: List students whose birth date is in next...
Sql Birthdate Query
In this post you will learn how to find birth date of customer or student. We will use getdate()...
Add Multiple Records To A Table With One Query In Sql
In this post we will learn how to add multiple rows to a table with one query. TO DOWNLOAD THE...
List Random Records From Table In Sql Server
In this post we will learn how to list random record from a table in sql server. We will list the...
List The Oldest Record In Sql
We will write some example about oldest and youngest records in sql query. To find oldest record we...
Join Same Table Twice In Sql Query
Sometimes, we need to join same table twice in a query. The examples about this issue is at below...
List Same Column Multiple Times By Different Names In Sql
In Sql, we can list same column multiple times by differrent name in sql. We must rename the column...
Sql Group By Day Names
To qroup queries day name we must use datename function in sql. This function gets two parameter...
Create A Function Merge Two String And Returns It
We will create a function that merge two string value and returns it. It is a simple example. There...
Stored Procedure To Divide Numbers And Get Divided Value And...
In this post we will write a stored Procedure. We will divide numbers than we will get divided...
Stored Procedure To Find A Number Is Prime In Sql
We will write a procedure that finds given number is Prime. The procedure gets an integer...
Select All Columns With Group By
In this tutorial we’ll not use group by but we will group records. In other words we’ll...
Function To Find A Number Is Prime In Sql
We will write a funciton that finds given number is Prime. The function gets a number parameter...
Scalar Valued Function Examples
This post contains more than 5 units scalar valued function examples. With this examples you can...