Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   How will get distinct records in SQL table? (http://www.go4expert.com/forums/distinct-records-sql-table-t29955/)

sql-programs 2Jan2014 12:01

How will get distinct records in SQL table?
 
For examble:

In a table name like

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

How will get the name "Test" using distinct keyword?

shabbir 2Jan2014 15:10

Re: How will get distinct records in SQL table?
 
Not able to understand what you are looking for?

shashikantchauhan 30Jul2014 09:57

Re: How will get distinct records in SQL table?
 
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;


All times are GMT +5.5. The time now is 14:04.