CS TECHIIE
Menu

SQL Program 04: Display all students

Praveen KulkarniPraveen Kulkarni

SQL learning illustration

CS TECHIIE | SQL Notes and Solutions

Practical SQL exercise: Returns all rows and columns.

Objective

Returns all rows and columns.

Explanation

Read the statement clause by clause and predict the result before executing it. These examples use common relational SQL; table setup and exact syntax can vary between MySQL, PostgreSQL, SQL Server, Oracle and SQLite.

Safety check

Before running UPDATE or DELETE, run a SELECT with the same WHERE condition. Use a test database and a transaction for changes you need to verify.

Program / SQL Solution

SELECT * FROM students;

Practice and revision

  • Run the example and verify the output.
  • Change the input and test normal, boundary and invalid cases.
  • Write the solution again without looking at the notes.

Learn • Practise • Build • Secure — CS TECHIIE