
Featured
- 
            
              Find out a particular column throughout the database in PostgresqlPreviously 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... 
                       
        
        
 
        
        