StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONeed help for complex data sort SQL Server
primarykey
Id
11683134
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-07-27T07:19:05.697
FavoriteCount
0
LastActivityDate
2012-07-27T08:42:12.133
LastEditDate
2012-07-27T08:42:12.133
LastEditorUserId
13302
OwnerUserId
508127
ParentId
0
PostTypeId
1
Score
1
ViewCount
202
LastEditorDisplayName
text
Body
I need help for complex data sort from database. Suppose my data stored in table like this: <pre><code>Description -------------- JCB Excavator - ECU P/N: 728/35700 Geo Prism 1995 GEO - ABS #16213899 GEO pump Geo Prism 1995 - GEO ABS #16213897 Geo Prism 1995 - ABS #16213897 Ersatz Airbags, Gurtstrammer und Auto Körper Teile this test JCB pipe & JCB pump Wie man BBA reman erreicht </code></pre> 7 rows are there. I want to write a SQL query in such a way as a result it will sort data based on my input word. Suppose my search term is <code>GEO,JCB</code> two words together separated by comma. The rows that will come first are those where search word found maximum time. So for <code>GEO</code> the word has the maximum time in most of the rows. Two sorts will be required: <ul> <li>first sort data in such way where search term found maximum time.</li> <li>second sort data on the basis maximum occurrence of search term found in each rows.</li> </ul> Suppose <code>GEO</code> the search term found in maximum row. So all the rows that have <code>GEO</code> keyword will come first and then <code>JCB</code> related data will come. In <code>GEO</code> related data those rows will come first that have maximum <code>GEO</code> keyword. So the output will be look like. <pre><code>Description -------------- Geo Prism 1995 GEO - ABS #16213899 GEO pump Geo Prism 1995 - GEO ABS #16213897 Geo Prism 1995 - ABS #16213897 this test JCB pipe & JCB pump JCB Excavator - ECU P/N: 728/35700 Ersatz Airbags, Gurtstrammer und Auto Körper Teile Wie man BBA reman erreicht </code></pre> Please help me to construct this kind of sql which will work in all SQL Server version.
Tags
<sql><sql-server>
Title
Need help for complex data sort SQL Server
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmarc_s
UserOwnerUserId
1. USThomas
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTDuplicate
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PONeed help for complex data sort SQL Server
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.