Featured
-
Find out a particular column throughout the database in Postgresql
Previously got a situation where I needed to get t
by Nitika.Verma
Tags
SQL: WHERE ,AND and OR Clause
1. SQL WHERE Clause:-
SQL WHERE Clause is one of the most useful feature of the SQL query as it is used to specify a condition while fetching the data from single table or joining with multiple tables,it also allows you to select specific ...
SQl:Create,Drop and Select Database Commands
1. CREATE DATABASE
Create database is a type of command used to create new SQL database.
Here is the syntax of CREATE DATABASE statement:-
CREATE DATABASE DatabaseName;
2.DROP DATABASE
Drop database is a type of command used to...
Difference between @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT
In most of our applications, We need last inserted identity value in SQL Server table. For getting the last inserted identity value we have multiple options:
@@IDENTITY
SCOPE_IDENTITY
IDENT_CURRENT
All these three return the l...