Solved

How to Arrange data Together

Posted on 2014-02-11
2
236 Views
Last Modified: 2014-02-18
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
0
Comment
Question by:Asrar Azmi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
Luis Pérez earned 500 total points
ID: 39850051
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
 
LVL 66

Expert Comment

by:Jim Horn
ID: 39850070
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question