SQL Server tutorial:-
Click here to see solution of given below description
SQL Server Management Studio (SSMS), is the client tool that can be used to write and execute SQL queries.
1-Creating Table and identity column
2-How to get the last generated identity column value in SQL Server?
3-Select specific or all column and Distinct row
4-Aggregate Function