Ravindra BagaleCourses & study guides Track your progress

SELECT Basics: Read Rows Without Changing Data

By Last updated:

Lessons in this chapter:

  1. 3.1 What SELECT Does (Read Only — Safe to Practise)
  2. 3.2 How to Select All Columns with SELECT *
  3. 3.3 How to Select Specific Columns and Change Column Order
  4. 3.4 How to Rename a Column in the Result with AS (Alias)
  5. 3.5 How to Preview Safely with LIMIT
  6. 3.6 Practice: First Queries on raja_coffee Orders

Quiz for this chapter is available on the Learn tracker after deploy.

Ravindra Bagale's Tip

Finish every lesson example in DB Browser before the quiz.

Ravi Sir's Cards for this chapter

SELECT basics. You should read a table safely before you change anything in it.Revision cardWhat does SELECT do? SELECT reads rows from a table and shows them to you. It does not delete or update anything.Interview cardSELECT * vs named columns. SELECT * returns every column in the table. Naming the columns returns only the columns you list.Comparison card

All cards for this chapter