Suoritettu

quick ms sql query - group and order

have database with half dozen fields two of which are xtime and xfrom - xtime is datetime field and xfrom is string with phone numbers. I need a query that will get me a listing that includes all records that has the records in descending time order - but has all the phone numbers grouped - so it only uses the time of the first record with that phone number - so I have 50 records over 10 hours - I need the records shown with most recent phone number and then all of the records for that phone number - then the next phone number by time desc. and all the records for that - etc. etc.

I am doing in a web page so i can do a loop with more than one query if that helps - just can't seem to figure out how to make this work easily.

Taidot: Tietokantaohjelmointi, Microsoft SQL Server, SQL

Näytä lisää: select group by order by, order by and group by in same query, group by sql, sql sum group by, having sql, sql server group by order by, sql order by, order by and group by together in sql, sql query zen cart database, web interface ms sql database, sql query ascending order days week, ms sql query mysql convert, convert ms sql query mysql, sql query sql database size, sql query date ascending order day, sql query order last date, sql query remote database mysql, sql query find last order date, database sql query oracle help, sql query check performance database

Tietoa työnantajasta:
( 416 arvostelua ) Davenport, United States

Projektin tunnus: #16530651

Myönnetty käyttäjälle:

sun0815

Hello. I read your decription very carefully. I am very interested in your job. I am a sql expert. So I can finish your job in a short time. I'd like to discuss more details via chat. I will wait for your rep Lisää

$25 USD 1 päivässä
(3 Arvostelua)
2.2

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$35 USD 1 päivässä
(16 arvostelua)
5.5
logiclast

Hi Dear, I am having an expert level knowledge in DotNet and SQLSERVER. I would love to work in this project to help you get the details of your need. Awaiting your positive response. Regards, Mayuri Patel.

$35 USD 1 päivässä
(3 arvostelua)
4.1
PATechnology

A proposal has not yet been provided

$20 USD 1 päivässä
(13 arvostelua)
3.5
Shattenjagger

Hello. Pretty complex query combining temporary view and actual table. But anyway, that’s possible to do. Let’s talk and do the business!

$30 USD 1 päivässä
(2 arvostelua)
2.9
Eagles90

Dear Client Ready to do it for you now! I have understood your requirements and ready to go for it right away. Warm Regards Z

$25 USD 1 päivässä
(1 arvostelu)
2.8
periyannas

Ok. help you immediately. -----------------------------------------------------------------------------------------------------------------------------------------------------------------

$25 USD 0 päivässä
(5 arvostelua)
2.3
itoasis1

Hi. I have review your project description. I have full experiences in Development. I am very interested in your project and also ready to start work immediately. Hoping for your soon Reply. Thank You Regard.

$25 USD 1 päivässä
(1 arvostelu)
1.8
Rebeater

Hi, I'm a software developer. I have 2 years of experience in SQL Server in business projects with modules such as: Inventories, personnel control, customers, users, reports, sales, among others. I am interested in Lisää

$18 USD 1 päivässä
(1 arvostelu)
0.2
brianconey

Hi there I have read your job description in detail . I can solve your problem . It is a piece of cake Please contact me and Let 's discuss more thanks for your posting . hope to hear from you .

$25 USD 1 päivässä
(0 arvostelua)
0.8
$25 USD 1 päivässä
(0 arvostelua)
0.0
manuelvalle1984

Not sure what is the result but I have a lot of experience with T-SQL in SQL Server, so, I'd like to have the chance of helping you

$25 USD 1 päivässä
(0 arvostelua)
0.0
$30 USD 0 päivässä
(0 arvostelua)
0.0
michaelll111

Hi, I will do it now. I will do it now. I will do it now. I will do it now. I will do it now. Regards

$25 USD 1 päivässä
(0 arvostelua)
0.0
rkmuduli1

A proposal has not yet been provided

$25 USD 1 päivässä
(0 arvostelua)
0.0
chaitanyaalapat4

As I am having 5 years of experience in SQL in MNC and have developed so many queries similar to this

$25 USD 1 päivässä
(0 arvostelua)
0.0