I have a database table..i want to write a stored procedure to SELECT the table..
the condition is.. i need to select only any one of the rows if two rows have a same column value..
i.e if there is a student table with columns id,name,subject
and the table has 2 rows with same studentname..i need only any one row while selecting complete row
how to do??