programplug Logo



SQL Select Statement

SQL;



SQL Basic

» SQL Introduction

» What is SQL?

» What is RDBMS?

» Syntax In SQL

» Data Type In SQL

» Operators In SQL

» Truncate

SQL Table

» Table

» Table Variable

» Create Table

» Copy Table

» Alter Table

» Drop Table

SQL Commands

» Commands In SQL

» Create Statement

» Select Statement

» Delete Statement

» Drop Database

SQL Clause

» WHERE Clause

» AND Clause

» OR Clause

» WITH Clause

SQL Keys

» Primary Key

» Foreign Key

» Unique Key

»Null Value

» Not Null Value

SQL Joins

» Joins

» Inner

» Full

» Left

» Right

SQL Order

» Order By

Select Statement In SQL:


The SELECT statement is used to select the data from the database.By using SELECT command you can fetch the record from the table "using WHERE Clause". Syntax: SELECT column_name FROM table_name; If you want to retrive the value of all the coloumns you can put this syntax: SELECT * FROM table_name;

The SELECT statement is used to select the data from the databse.By using SELECT command you can fetch the record from the table "using WHERE Clause"..
Syntax: 

SELECT column_name FROM table_name;

If you want to retrive the value of all the coloumns you can put this syntax:


SELECT * FROM table_name;