What is the best way to fetch data from table

Question

There is two way to fetch the data from table. which one should i use.

a> select * from table name?

b> select coulmn1, column2,... from table name?

Answer 1

Hey Shraddha,

I understand your doubts about fetching the data from the table. But Select * is not efficient to fetch the data. It is time-consuming and less efficient. 

So if you go for mentioning the columns in your table it will be more efficient. 

Select column1,column 2 ...from table;

I hope this answer will help you to understand the concept.