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