SELECT Query in DBMS

Displaying only specific columns using SELECT Query in DBMS

Consider a table student where you need to display a student name, ID, and score

SELECT stuid,sname,score 
from student;

O/P

Display all records present in the table using SELECT Query in DBMS

The ‘*’ operator is used to display  all the columns present in the table

SELECT * from student;

All the columns in the table get displayed.

 Retrieve  records based on some specified condition

Only those records that satisfy the condition specified in the ‘where’ clause are displayed

Display records of those students from the computers department

SELECT * from
student
where branch='computers';

O/P

Performing some calculations on the column using SELECT

• We can use simple arithmetic operators upon column data while displaying records
• But these changes are not affected in the actual database table they are just  used for display purpose

Increase score of students by 5 marks who are having a score greater than 80

SELECT stuid,sname,score,score+5 
from student
where score>80;

O/P 5 marks will be added to all students who are having ‘score’ greater than 80 are displayed