Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dinstinct results for Full Text Search

Status
Not open for further replies.
cash0

cash0

Programmer
May 23, 2001
22
AU
I'm doing a SQL Server full text search, but it is returning duplicate results.

I've tried to do a SELECT DISTINCT but it won't work because the page rank is unique for each record. I ORDER BY RANK so I need to select it.

Is there a Full Text Search option that I can use to stop duplicate records from being retured?

Thanks.
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Returns wrong results
Replies
1
Views
97
Cpreston
Cpreston
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
109
grnzbra
grnzbra
ahmedsa2018
  • Locked
  • Question
How to display part number based on search string by chemical id ?
Replies
3
Views
120
gmmastros
gmmastros
bmacbmac
  • Locked
  • Question
SQL 'For json' query for over 100,000 records - truncating results
Replies
2
Views
251
bmacbmac
bmacbmac
WomanPro
  • Locked
  • Question
How to display the results of my query delimited with pipes?
Replies
9
Views
150
WomanPro
WomanPro

Part and Inventory Search

Sponsor

Back
Top