select query in sql | Sharp Tutorial

SQL Select Query

Select SQL query may be used to fetch the records from a table or group of multiple tables.

Syntax : select * from <table-name>;

    select * from Student;

Above query Displays the records with all fields as following.

Syntax : select field1,field2 from <table-name>;

    select rollNo,Name  from Student;

Above query Displays the records with selected fields as following.