Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

SQL Select statement in database systems

What is the SELECT statement?

The select statement is used to display the values from the table.

RollNoNameFee
1Sameed10,000
2Shahzeb10,000
3Basit0.00

Table 1: student

Example 1:

Query on table 1: SELECT * FROM student;

Result:

RollNoNameFee
1Sameed10,000
2Shahzeb10,000
3Basit0.00

Query show the resultant table: student


Example 2:

Query on table 1: SELECT RollNo, Name FROM student;

Result:

RollNoName
1Sameed
2Shahzeb
3Basit

Query show the resultant table: student


Example 3:

Query on table 1: SELECT RollNo FROM student;

Result:

RollNo
1
2
3

Query show the resultant table: student

 

Fazal Rehman Shamil Click Here to Know More
Instructor, Researcher, Blogger, SEO Expert, Poet and Publisher of International Journal Of Software, Technology & Science ISSN : 2616 - 5325
Dear Professors and Resarchers!You are welome to Cite these tutorials in your research or slides etc. Please don't forget to mention the reference of website. Copy Paste of text is strcitly forbidden. Images can be reuse because images are protected with watermark.

Leave a Reply

Your email address will not be published. Required fields are marked *