quick ms sql query - group and order
Bütçe $10-30 USD
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.
Seçilen:
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 Daha Fazla
Bu iş için 16 freelancer ortalamada $26 teklif veriyor
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.
Hello. Pretty complex query combining temporary view and actual table. But anyway, that’s possible to do. Let’s talk and do the business!
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
Ok. help you immediately. -----------------------------------------------------------------------------------------------------------------------------------------------------------------
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.
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 Daha Fazla
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 .
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
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
As I am having 5 years of experience in SQL in MNC and have developed so many queries similar to this