Question

select * from employee;

What does the above query do?

i. It gives all the tuples of employee table

ii. It gives error message

iii. It gives employee attribute of all the tuples

iv. It gives first tuple value




Pls give verified answer......​

Answer 1

it gives all the tuples of the employee table.

* is used as a wildcard which shows all the tuples in a table in SQL.