Duplict rows

Duplict rows.

SQL duplicate records duplicate records.If you point to otherwise ,the ruselt of a query contains all the rows of a cloumn.for example if you select the department numbers  from the emp table ,the result displays all department numbers, including repeted department numbers .

Please check the below example