How to Arrange data Together

Hi Experts,
I am sending an image can you check and let us know how we can display data together of particular vehicle in sql server 2008 by orderly .


Thanks in advance
TableData.png
Asrar AzmiWeb DeveloperAsked:
Who is Participating?
 
Luis PérezConnect With a Mentor Software Architect in .NetCommented:
What you need is to group by that column.

Check the GROUP BY syntax here:
http://technet.microsoft.com/en-us/library/ms177673.aspx

Hope that helps.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Here's an article on SQL Server GROUP BY Solutions that would be a good read for you.

>how we can display data together of particular vehicle in sql server 2008
GROUP BY will group records by whatever column you choose, in this case vehicle.  You'll want to put some thought into which columns you want to display and which ones you don't.  Looking at your screen shot, you can return a set with 5624, 6684 as single rows, but you won't be able to display other columns with different values, such as speed.

You'll want to spell out in detail what you want to display, and we'll help with that.

>by orderly .
Not sure what you mean here.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.