12-25-2013, 12:32 AM
|
#1 |
|
Registered User
Join Date: Nov 2013
Posts: 92
|
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?
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. |
|
|
|
03-17-2014, 04:43 AM
|
#2 |
|
Registered User
Join Date: Mar 2014
Posts: 10
|
Code:
select distinct column_name from table_name
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. |
|
|
|
 |
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to prevent SQL injection in PHP? | Jack Hard | PHP / mySQL | 0 | 05-06-2013 04:46 AM |
| Windows Hosting on IIS 8 Server with Free SQL 2012 Database | thewebhosting | Web Promotion | 1 | 04-04-2013 08:53 AM |
| SQL Server and PHP | williamcastro22 | PHP / mySQL | 16 | 06-04-2012 02:14 AM |
| statistics from mysql table | ncjbhd | PHP / mySQL | 0 | 10-27-2011 01:24 AM |
| pagination all records | mjvndhsb | PHP / mySQL | 0 | 10-26-2011 11:29 PM |
All times are GMT -7. The time now is 08:15 PM.