SQL SELECT Statement

0
320

sqltuts

The SELECT statement tells what is to be returned. ‘*’means all the columns from all tables in the from statement are to be returned.

 

Syntax:

For example, we have this table Employee:

Employee_id First_name Last_name sex
123 Mack Johnson male
124 Jack Obama male
125 King Khan male

 

Now, we want to select two columns Employee_id and First_name:

This would give the following result:

Employee_id First_name
123 Mack
124 Jack
125 King

The above command would display the whole table.

Previous articleComplete Inventory Management Software
Next articleSQL UPDATE Statement
Hello Itsourcecoders, welcome to itsourcecode.com. I'm Joken Villanueva, MIT a passionate Blogger, Programmer and a Hobbyist. I started Itsourcecode because I wanted to give back and Share all the learnings and knowledge I've learned in my career and I believe through this website I would be able to help and assist those newbie programmers in enhancing their skills from different programming languages. So let us all help each other by sharing our ideas!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.