SQL formula help

$10-30 USD

Κλειστή

Αναρτήθηκε

περίπου 7 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

I have a small project that requires the use of SQL. I'm not as familiar with this language and so I need some help. The main objectives give me the formulas or expressions for the following if its possible: 1. Formula for searching data from one year ago to the current date. Obviously, every time the query is executed the date would change. 2. Convert a data type from a graphic to a numeric. 3. Search data for a character and return the highest character. For example, if a column has an "A" and a "B" character, it would only return the data with the "B" designator.

SQL

Ταυτότητα εργασίας: 14583287

Σχετικά με την εργασία

52 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

52 freelancers δίνουν μια μέση προσφορά $25 USD για αυτή τη δουλειά

@Paznek

Hello, I'll give you instruction to complete the project. Q1 , dateadd(curdate(), interval -1 year) Q3, do characters in column are "sorted" ? ABC, DCF ? if yes use right(column, 1) Relevant Skills and Experience Check my review, I do know MySQL, MSSQL, SQL in general Proposed Milestones $10 USD - Query 1 $10 USD - Query 2 $10 USD - Query 3 Additional Services Offered $50 USD - New Query, 1 hour time

$30 USD σε 1 ημέρα

5,0

(14 αξιολογήσεις)

6,7

@codetod

SQL expert with 12 years of database programming and administration experience. I can do the tasks right away. Relevant Skills and Experience MS SQL Programming, SQL Administration, Query writing Proposed Milestones $25 USD - On completion Can we please discuss and finalize this.

$25 USD σε 1 ημέρα

5,0

(75 αξιολογήσεις)

6,3

@yony82

A proposal has not yet been provided

$15 USD σε 0 ημέρα

5,0

(17 αξιολογήσεις)

6,0

@khantek

Hi, I am very much interested to assist with you. I can write the SQL formulas for you. This is quite simple and easy. Please let me know if you accept so I can get this done for you asap. Relevant Skills and Experience SQL Proposed Milestones $30 USD - Upon Completion

$30 USD σε 1 ημέρα

5,0

(18 αξιολογήσεις)

5,6

@jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). Relevant Skills and Experience I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). Proposed Milestones $40 USD - cost

$40 USD σε 1 ημέρα

4,9

(29 αξιολογήσεις)

4,9

@smartstepsco

I'm developer with 12 years experience on .net framework and MsSqlServer Relevant Skills and Experience I can do this with Tsql Proposed Milestones $35 USD - offer

$35 USD σε 1 ημέρα

4,9

(8 αξιολογήσεις)

4,8

@IMExpertEngineer

Hi, Are you using sql server or my sql or any other database. Please explain to me this then I can help you as per your requirement. Thanks

$35 USD σε 2 ημέρες

5,0

(5 αξιολογήσεις)

4,5

@vinaysinghh

A proposal has not yet been provided

$30 USD σε 1 ημέρα

4,6

(31 αξιολογήσεις)

4,6

@vw7590795vw

A proposal has not yet been provided

$24 USD σε 0 ημέρα

5,0

(21 αξιολογήσεις)

4,0

@davedcb

Hello I am interested in your project Relevant Skills and Experience I am a software developer with professional experience in SQL. Proposed Milestones $25 USD - Query

$25 USD σε 1 ημέρα

5,0

(17 αξιολογήσεις)

4,0

@carlamorillo2

Hi, I think I can help you with your project. The description is pretty clear but need some details on what does "greaphic to numeric" mean. The rest are simple queries and SQL functions. Relevant Skills and Experience I'm a DBA professional working at a bank institution with 2 years of experience. Proposed Milestones $20 USD - Milestone1 Additional Services Offered $10 USD - Entity Relationship model, Relational data model, diagrams, etc... conversion, what does "graphic to numeric" mean? Also, what DB Manager are you using?

$20 USD σε 2 ημέρες

5,0

(8 αξιολογήσεις)

3,5

@sveralex

Hello I'm an SQL expert? Would you like to get just sample queries, or prefer sql statements working with your particular database? -- Thank you. Alexey Relevant Skills and Experience I possess a vast 20+ years experience in database development Proposed Milestones $23 USD - Milestone #1 About item #3 Can you post some sample data with this column

$23 USD σε 1 ημέρα

5,0

(4 αξιολογήσεις)

3,2

@pramsweety

Dear, Thank you for posting a job on my favorite technology i.e., Microsoft SQL Server. I have been working with Microsoft SQL server for the past 5 years in ERP, Big Data and Data warehousing environment. I have been developing and coding SQL using complex procedures and functions. I have also completed certifications on SQL and PL/SQL with 95 percentile. I am sure that my skills and experience are suitable with your job requirements. I am so happy I get a chance to get connected. Thanks for your attention. Yours sincerely, Pramila

$27 USD σε 1 ημέρα

5,0

(6 αξιολογήσεις)

3,0

@sljukic

I can make your queries Relevant Skills and Experience SQL Proposed Milestones $50 USD - Upon project completion

$50 USD σε 1 ημέρα

5,0

(1 αξιολόγηση)

2,6

@croca

I have 25 years of experience as database administrator and developer. Relevant Skills and Experience oracle, mysql, ansi SQL Proposed Milestones $21.5 USD - no need $12.5 USD - no need Honestly, 2nd item seems complicated, and dealing with graphic is database provider dependent

$25 USD σε 1 ημέρα

5,0

(2 αξιολογήσεις)

1,9

@Walrusyn

Hi, I'm a sysadmin with 16 years of experience and plenty of SQL experience and would love to help you with this task. Just need to know the schema of the DB. Relevant Skills and Experience MySQL, SQL Proposed Milestones $25 USD - create sql queries

$25 USD σε 1 ημέρα

5,0

(2 αξιολογήσεις)

1,4

@victorhcc

I can help you with the sql sentences that you need.

$20 USD σε 1 ημέρα

5,0

(2 αξιολογήσεις)

1,2

@forususa

Dear Employer , we are experts in Microsoft BI stack , SQL Server ,C# , ASP.Net . we work for Microsoft as consultants and this is first time we are entering into the freelancing world. we are good at data entry projects and filling forms or websites. we have expertise in Excel Macros , Excel Dashboards , spread sheets , tables ,excel analysis etc... we are certified from Microsoft in SQL Server , Oracle ,MSBI. we want to make our foot prints so strong in freelancing world and we need a opportunity to prove our self. we have completed 2 projects successfully and looking forward to work with you. Looking forward to hear from you. Please feel free to ping us.

$25 USD σε 1 ημέρα

5,0

(2 αξιολογήσεις)

1,3

@nidhi0257

4.5 years of IT experience in software development on Core java, J2EE, Spring, struts 2, web services, Cobertura, restful interface, JSON, MQTT client, spring MVC, mosquitto, Amazon s3. Relevant Skills and Experience 4.5 years of IT experience in software development on Core java, J2EE, Spring, struts 2, web services, Cobertura, restful interface, JSON, MQTT client, spring MVC, mosquitto, Amazon s3. Proposed Milestones $17.5 USD - First $17.5 USD - Second

$35 USD σε 1 ημέρα

5,0

(1 αξιολόγηση)

0,7

@zeljkooroz

Hello. I am very experinced with sql server, and working with mssql over 4 years. This project would mean very much to me and my profile summary Thank you!

$20 USD σε 1 ημέρα