Executing the select queries in SQL plus

The select queries is used to fetch the data from the database .We can also use FROM to fetch the data from the table based on certain selection or condition.

The below figure shows how to execute the select command.

• 
• Fig 7.4

• 
• Fig 7.5

SELECT USING FROM

The below figure shows that the query to fetch the data from the table students where id is equivalent to 6 is executed and the results are shown.

• 
• Fig 7.6

• 
• Fig 7.7

The above Fig 7.7 shows how to execute the query with select using from and to fetch the data or populate the data in a selective manner.