Retrieve Unique Value from Table Column with Using DISTINCT & GROUP BY Keyword

Emp_id	Emp_name	Emp_mob
1	Suryagroops	9532771738
2	Suresh	9452358456
3	Mayank dixit	9896564556
4	Suryagroops	9878522132
5	Ramesh	8004677781
6	Ramesh	8785455852

                                                                                               

                                                   Figure: suryagroops_0003 (tbl_emp)

DISTINCT

Select DISTINCT Emp_name from tbl_emp;

GROUP BY
 

Select Emp_name from tbl_emp GROUP BY Emp_name;

Result-

Emp_name

Suryagroops

Suresh

Mayank dixit

Ramesh

Clause In Select Statement

• SELECT 

             SELECT * FROM table_name;

• WHERE CLAUSE

              SELECT * FROM table_name WHERE condition_statement;

• DISTINCT CLAUSE

             SELECT DISTINCT Column_Name1, Column_Name2 From table_name;

• AND/OR Clause

              SELECT Column_Name1, Column_Name2 FROM table_name WHERE Condition_Statement1 (AND/OR) Condition_Statement2;

• IN Clause

             SELECT Column_Name1, Column_Name2 FROM table_name WHERE Column_Name (value1, value2……….valuen);

• BETWEEN Clause

             SELECT Column_Name‘s FROM table_name WHERE Column_Name BETWEEN value1 and value2;

• LIKE CLAUSE

             SELECT * FROM table_name WHERE Column_Name LIKE (statement);

• ORDER BY CLAUSE

            SELECT * FROM table_name WHERE Condition ORDER BY Column_Name (ASC/DESC);

• GROUP BY CLAUSE

           SELECT SUM (Column_Name) FROM table_name WHERE Condition GROUP BY Column_Name;

• COUNT CLAUSE

           SELECT COUNT (Column_Name) FROM table_name WHERE Condition;

• HAVING CLAUSE

            SELECT SUM (Column_Name) FROM table_name WHERE Condition GROUP BY Column_Name HAVING (Arithematic_Condition);

Database Action Query

INSERT QUERY 

INSERT INTO Table_Name (column_name1, column_name2) VALUES (Column_value1, column_value2)

UPDATE QUERY

UPDATE Table_Name SET Column_Name1 = Column_Value1, Column_Name2=Column_Value2 WHERE Column_ID=Value_ID 

DELETE QUERY

1. DELETE FROM Table_Name [It delete whole table ]

2. DELETE FROM Table_Name WHERE  Column_ID=Value_ID  [it deletes one row of table using by Column_ID]

SELECT QUERY 

1. SELECT * FROM Table_Name [it select whole data of specified table]

2. SELECT * FROM Table_Name WHERE Column_ID=Value_ID [it select row data of specified table using by Column_ID]

Make Table In Sql Server

Create Table tbl_cust

(Cust_ID int Not Null,Cust_Name nvarchar(20) Null,Cust_Age int Null check (Cust_age >= 18),Cust_Address Char(50) Null,Cust_Salary Decimal(18,2),Primary Key(Cust_ID));        

Note  

Also specify column[cust_id(primary key)] property’s ----- Indentity specification is  yes at save time table.

Insert Query 

INSERT INTO tbl_customer (Cust_Name,Cust_Age,Cust_Salary,Cust_Salary) VALUES(‘munim ’,’50’,’40,000’,’pk-215 kanpur’);

INSERT INTO tbl_ customer (Cust_Name,Cust_Age,Cust_Salary,Cust_Salary) VALUES(‘mahesh ’,’30’,’25,00’,’ok 412 rbl’);

INSERT INTO tbl_ customer (Cust_Name,Cust_Age,Cust_Salary,Cust_Salary) VALUES(‘suresh ’,’24’,’35,000’,’h n 215 rbl’);

INSERT INTO tbl_ customer (Cust_Name,Cust_Age,Cust_Salary,Cust_Salary) VALUES(‘manish ’,’26’,’15,000’,’ck 10/20 vns’);

INSERT INTO tbl_ customer (Cust_Name,Cust_Age,Cust_Salary,Cust_Salary) VALUES(‘mac ’,’25’,’20,000’,’b-4/58 varanasi’);

Suryagroops: Making Table In Sql Server

Suryagroops: Make Table In Sql Server: Making table in MS SQL SERVER with design

SQL Normalization

Database Normalization :-

Database Normalization is the process of efficiently organizing data in a database. 

There are  two reasons of the normalization process----

 

•  Eliminating redundant data as – storing the same data in more than one table.
•   Ensuring data dependencies make sense.

ü      Normalization has three types -

• 1NF
• 2NF
• 3NF

 

SQL Brief Description

SQL is structure query language which is includes storing,manipulating,retrieving data  stored in relational database.

Dr. E.F. Ted  of +IBM  is the father of relational database which described relational model for databases.

                                                                         

SQL Process Diagram