quick ms sql query - group and order
$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.
プロジェクトID: #16530651
プロジェクトについて
14人のフリーランサーが、平均$26 で、この仕事に入札しています。
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
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 .
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.
Ok. help you immediately. -----------------------------------------------------------------------------------------------------------------------------------------------------------------
Hello. Pretty complex query combining temporary view and actual table. But anyway, that’s possible to do. Let’s talk and do the business!
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