Monday, April 11, 2016

What is a SELECT statement?

Select statement returns all that we want show in query result .It brings the row and column that we are query for. In this lesson we learn more important thing about Select query. In this SELECT query it select all the  first name and last name from the table join together and represent as a full name.



firstname
lastname
Sun
Moon

select 
firstname + ' ' + lastname As Fullname
from student;


Query  Output :

Fullname
SunMoon



No comments:

Post a Comment