Question

Does a HTML SQL query eliminates duplicates

Answer 1

Answer:

SQL query will not automatically eliminate the duplicates , explicitily we have to use distinct keyword for removing duplicates from result set. If there is no indexes it will create index automatically. No two column can have the same name.