How will get distinct records in SQL table?

sql-programs's Avatar, Join Date: Oct 2009
Go4Expert Member
For examble:

In a table name like

1.Test
2.Test.
3.Test..
4.Test...

How will get the name "Test" using distinct keyword?
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Not able to understand what you are looking for?
0
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;