Question

In SQL (*)all field where is used

Answer 1

it is used where u want to get all rows or can say data satisfied to a criteria.

for example i want all students who got total marks greater than 400

so

select * from students where total_marks > 400

it will return all students satisfying the criteria.

its also used with count to get total number of such data. for example to get count of above query i have to use

select COUNT(*) from students where total_marks > 400