how to combine my Distinct valuein query

Question

User332347244 posted

i want to combine all distinct rows in my query....like to display the same sentence length,person and city all together. i have been able to combine the sentence but perosn and city try to combine it gives me error.how can i combine them into distinct value.

sentence	person	city
365	Tom	Washington
30	Mark	California
365	Mark	washington

thanks in advance

Answer 1

User-1716253493 posted

 CONVERT(varchar, sentence) + person + city AS combined

Answer 2

User332347244 posted

hi oned_gk,

i have my query like

select sentence, person city
from test
where where SentenceDate between @startdate  and @enddate.

so how can i conver this into query

Answer 3

User-1716253493 posted

I am not sure understant what you want. Would you like to explain with some sample data and output you want?

Answer 4

User332347244 posted

hi oned_gk,

i would be much grateful if you could explain with some sample data and output you provided..it will be helpful and much understandable.Cause im not sure on how to edit or change the code i have

thanks in advance

Answer 5

User2105670541 posted

try to use a query like below:

select distinct convert(varchar,sentence+ ' '+ person+ ' '+ city) as details
from test
where where SentenceDate between @startdate  and @enddate.