Thursday, April 10, 2014

How To Get Unique Record From Table In Php??

How To Get Unique Record From Table In Php??

To get unique record from table you can use DISTINCT keyword in query.
Using DISTINCT keyword you can get unrepeated records from the table


Syntax:
SELECT DISTINCT columnname, columnname, … FROM tablename;

Example:-
To select only unique rows from emp table

SELECT DISTINCT * from emp;

Mail Motor Service 17 Driver Recruitment 2014 davp.nic.in
·          


No comments:

Post a Comment