Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
i have a query which has some duplicate record how i can supress the duplicate records.thanksurgent please
Use DISTINCT clause:http://www.webcheatsheet.com/sql/interacti...ql_distinct.php