Sql server queries

Hello there, in this case we can use the lead and lag function to idenfy the next value and we will subtract, if more than 5 mins we will increase the group number by one. Finally we can group by by the number. Waiting Mai multe

Hi I'm an Access/Excel/SQL/VBA expert and a mathematician from Georgia- a full-time freelancer. I have been coding for over 20 years in this field. I can code it via ms Access query. Please visit [login to view URL] Mai multe

Hi there! Let me help you out... I would like to help you to write the SQL Query to find the 5+ minutes gap between two timestamps and do some data processing.. I know 500-level things about Microsoft SQL Server. I h Mai multe

MASTERS IN SOFTWARE DEVELOPMENT AND ARCHITECTURE. Hi there! I have carefully read the project description and I would like to take part in this project. I will work according to your requirement to provide the best qua Mai multe

I can help you with sql server queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me kno Mai multe

SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from t Mai multe

Hi there, I am Rashid. Hope you are doing great. Firstly about the Sql server queries that I have a great experience in it. I am very confident to pull it off once awarded. I have good experience in Microsoft SQL Serv Mai multe

Hi, Query is ready. Please message me to get it right now Thanks

Hi, I can set the SQL quires perfectly. Please share with me more details. I'm an experienced web developer with the necessary skills for getting this job done. I am available to start immediately. I will provide a gre Mai multe

Hello James N., I have gone through your project description and it seems like I'm a great fit for this job. I'm a professional software engineer with many years of experience in Database Programming, Microsoft SQL Mai multe

Hello I hope you are okay. Thank you for the opportunity to bid. I am a Mean & Mern stack developer with rich experience in DB manipulation. Database management in particular is very important to me as a web developer Mai multe

Hi, To split rows into groups based on a gap of more than 5 minutes between timestamps, you can use the LAG function to retrieve the previous timestamp value and calculate the time difference. Then, use a cumulative su Mai multe

I am a highly skilled Data Analyst and Data Scientist with 2 years of experience in coding. My expertise includes statistics, Tableau, SQL, Python, Pandas, NumPy, Matplotlib, data wrangling, professional EDA, data entr Mai multe

Hi I am very proficient with queries and can write optimized queries. I am aware of joins, pivot, unpivot, CTE etc.

I am a Data Analyst and working with data for the last 6 months and having advanced expertise in Python, Excel, SQL, Power BI, Python Automation, Web scrapping, Google sheets, Excel Power query/automation, live dashboa Mai multe

CREATE TABLE [dbo].[Groups]( [Number] [numeric](18, 0) NOT NULL, [Group] [int] NULL ) ON [PRIMARY] GO ****************************************************** Below is the query. ************************************** Mai multe