Create a SQL Server Query for data from single table

select eItemKey, max(eInsertDateTime) OVER (PARTITION BY eItemKey) AS maxdate from tablename i hope this will work for you

dear allow me to help you i am a db administrator this is very simple

Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

I am 8+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my working domain. I am confident to complete the project.

Hi, I am 16+ years experienced oracle Certified Database Programmer at CMMI-5 level company. I am working on : RDBMS: MS Access, Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN,Oracle Foms, Oracle Reports, ADF I Can do your work easily. Let me know when we can discuss

You would like an SQL query that will return only one entry with the oldest date/time? It appears there is only one field in this .csv... are these separate fields in your sql database?

i see attach csv and ready to do this query and execute it lets start this job done and ready to start Thank you

Hi, I'm high rated coder from Ukraine. I've more than 12 years in the experiences of the database developing. My skills are includes MS SQL, PostgreSQL, SQLite, MySQL, MS Access, Sybase etc. Would you like to have T-SQL query to collect data? In this case, I'll need the table name. Thanks, Andriy

I have 3 years expertise developing software by .NET and SQL SERVER. I can help you finish this project with the best quality.

Hi, I can provide you with the query as I prepared good number of complex queries as part of sql development work. hope to hear from you regards Babu

can you please explain what you mean by oldest exactly? the 10 oldest for exampe ?

A proposal has not yet been provided

Hello, I have total 5 years of experience in various DBs like MS SQL server, MySQL, Oracle, DB2, Postgres etc. I also have very good command on SQL and PL/SQL. I really want to work on project as my skill sets best matches with your requirements and I assure 100% result in minimum time. Thanks for considering my profile in advance. Best Regards!!

sql expert here you need to hair me i can fix your problem i have 3 year experince just new on free lancer thanks regards tayyab

I need to understand the requirement correctly. Do u want one record of oldest time every day? Once I have answer I can do it.

I can do this. Freelancer cuts 5$ per project.. So If your budget is 10$ then I will get only 5$ thats why bidding 15$ Thanks

A proposal has not yet been provided

ear Buyer, I am interested very much for the specific project, due to my great experience in databases(Oracle,My SQL,Ms Access). If you would like to work with me, my strategy/method is be listed below: 1) Upload initial data to a Table(Oracle Express or My sql) 2) Data processing(Sorting,spliting,updating is much more easy here, also with minimum errors) 3) Check the results, find bugs/errors 4) Export the final data in xls format. Thanks in advance Jim

I have read your job description and I can surely meet the requirement of your job. I will deliver your work at my best earliest. You may also discuss it with me on Skype before selection. Please if you have any queries do let me know before the acceptance of proposal. Thanks Awaiting for your reply. Details: Skype: hmasif0f Programming languages and Databases: iOS, Android, C, C++, Objective-C, Java, C#(.NET), ASP.NET, VB.NET, MVC, Entity Framework, LINQ, PHP, Codeigniter, HTML, CSS, JavaScript, JQuery, AJAX, JavaServlet, XML, JSON, APIs, Web Services, MySql, Oracle, SQL MS-Office: Word, Excel, Access and Power Point

two queries are given below ... i am doing it for fun ... its up to you ... at least you should put a review if you cannot pay .. first query ... SELECT * FROM [EmployeeAck] where eInsertDateTime = (select min(eInsertDateTime) FROM [EmployeeAck]) second query .. SELECT TOP 1 [eInsertDateTime] ,[eID] ,[eItemKey] ,[EmployeeID] FROM [EmployeeAck] order by eInsertDateTime asc both do the same job ... i added your database on my server and tested them ... both check saved time stamp in database and based on it took oldest record ... ... My Pleasure to that ... God Bless You...

A proposal has not yet been provided