What is SELECT Query ?
SELECT:-
The SELECT statement is probably the most used statement n SQL command.
Syntax:-
Select * from Table_name
Example:-
Select * from Student
Case:- If we want to show only few column then we write this query.
Syntax:-
Select columnname1,columnname2,columnname3 from table_name
Example:-
Select StudentId,StudentName,RollNumber From Student
SELECT:-
The SELECT statement is probably the most used statement n SQL command.
Syntax:-
Select * from Table_name
Example:-
Select * from Student
Case:- If we want to show only few column then we write this query.
Syntax:-
Select columnname1,columnname2,columnname3 from table_name
Example:-
Select StudentId,StudentName,RollNumber From Student