For examble: In a table name like 1.Test 2.Test. 3.Test.. 4.Test... How will get the name "Test" using distinct keyword?
its table name and distinct is use for attribute which is called data in table. you have to find that which is is distinct then you can use this query SELECT DISTINCT column_name,column_name FROM table_name;
Specifies records selected with SQL queries. ... no duplicate CustomerID fields, but the Orders tabledoes because each customer can have many orders.