Newest 'SQL' development Blogs - database

database

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 SQL Server mysql Oracle mysql database SQL In operator SQL Server 2008 SQL wildcards Blog query WHERE clause Stored Procedure- Working XML sql joins Stored Procedure with arguments How to pass arguments to stored procedure stored procedure using parameter SQL ORDERBY Data Definition language SQL Delete Statement SQL Insert statement SQL Between Operator SQL less than Operator Categories of SQL Statements SQL Left Join SQL Distinct/Unique Statement SQL Inner Join Truncate Table php SQL Select TOP SQL LIKE Operator SQL ALIASES normalization Pivot in sql Restore XML how to connect with sql server . postgres particular column Use of Transaction and Try Catch in Stored Procedure Sys Commands Nth highest salary table Insert Data From One Table to Another Table in SQL ldf mdf Backup MSSQL Java

Normalization in database

SQL
NerdDigest
almost 8 years ago

Hi Reader's, In this blog we are going to discuss about the Normalization process with in the database.Database Normalization can be defined as a technique which is used to organize the data within the database. Databas...

SQL Basic Commands

SQL
NerdDigest
almost 8 years ago

SQL stands for Structured Query Language. SQL is a language which allow us to access data or modify data from the database. Before proceeding towards the SQL we should also know about database. DataBase can be defined as the collection of multipl...

Use of AVG() Function in MySql

SQL
NerdDigest
about 8 years ago

The MySql provides us with various for wide use for handling the database. The AVG() function is also one of the important function used in MySql. The AVG() is used to calculate the average value of the columns. Syntax: SELECT AVG(column-n...

what is the use of FORMAT() function in SQL?

SQL
NerdDigest
over 8 years ago

In SQL, FORMAT() function is used to format a column value means how a field will to be displayed. FORMAT() Syntax SELECT FORMAT(column_name,format) FROM table_name; In the above syntax parameters are as below: Parameter Descri...

what is the use of NOW() function in SQL?

SQL
NerdDigest
over 8 years ago

In SQL, NOW() function is used to return the current system date and time. NOW() Syntax SELECT NOW() FROM table_name; We have a table "employee" as below: employee id first_name last_name salary ........

Normalization

SQL
NerdDigest
over 8 years ago

Database Normalization Normalization is a technique of managing records in a database. It is an approach to eliminate data redundancy and anamolies . It also removes data duplicacy in a record. It helps in data update,delete and insert anamol...