STORED PROCEDURE

Question

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 idnamesubject and the table has 2 rows with same studentname..i need only any one row while selecting complete row how to do??

Chetan Ranpariya · Answer

If you do not have any criteria for selecting one record then you can use SELECT TOP 1 * FROM TABLE WHERE > This will return first and only one row always no matter how many rows are there matching the where clause. Thanks and regards Chetan Ranpariya

Suvendu Shekhar Giri · Answer

Agree with @Nitin here. Please share some sample data and answer other questions asked by @Nitin so that you will try to propose a good solution.

Nitin Sontakke · Answer

First what is the criteria to join two tables? Is it studentname if yes it is a very poor choice. Does 2nd table has student id? Second on what basis you do want to choose 1 record out of 2 records. For example latest record inserted etc. It is best if you show some sample source data and an expected output from that data.