Sql command to retrive all data froma table?

1 answer

Answer

1136087

2026-04-27 14:10

+ Follow

The SQL command that can be used to retrieve all data from a table is the SELECT

Ex:

Let us say we have a table called employee_master which contains 3 columns emp_name, emp_number, date_of_joining you can retrieve all the data by using the below command

SELECT * FROM employee_master

or

SELECT emp_name, emp_number, date_of_joining FROM employee_master

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.