When we should use *

Question

after select where we should use *

Answer 1

when you want 'any', and don't want a specific result

Answer 2

select * from <table name> ;

to display all records/rows/tuple of a table

Answer 3

Also as a parameter for aggregation functions like:

select count(*) from table;

Answer 4

to select aalll.columns

Answer 5

You can use it when u want to select all the columns