Link to home
Start Free TrialLog in
Avatar of Asrar Azmi
Asrar AzmiFlag for Saudi Arabia

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Luis Pérez
Luis Pérez
Flag of Spain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.