Find Jobs
Hire Freelancers

select query with same data as first product in query

€8-30 EUR

クローズ
投稿日: 5年以上前

€8-30 EUR

完了時にお支払い
Hello, I have following query: SELECT * FROM WWW_Stock_Cpnr_Winkel WHERE ArtikelKode = 'MKN198A005107M/659' I either want to select all products that start with same data before the backslash /. Any idea to make this? Thanks. Keep in mind the Artikelkode change each time. This query is just one example
プロジェクト ID: 18695349

プロジェクトについて

35個の提案
リモートプロジェクト
アクティブ 5年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に35人のフリーランサーが、平均€20 EURで入札しています
ユーザーアバター
Hello, As an expert in SQL, i am very much interested to write the required query. I understand what you need and i can do it in short time. Looking forward to have a positive response from you. Thanks
€19 EUR 0日以内
5.0 (291 レビュー)
8.0
8.0
ユーザーアバター
Hello Sir I can make the query to filter appropriate results.. before slashes. I am willing to start right away. Please check my profile for work and experience. Regards Ashwin
€29 EUR 0日以内
5.0 (393 レビュー)
7.4
7.4
ユーザーアバター
Hello sir, I hope you are good. Let me tell you I am Full Stack Web Developer having 5+ years of experience. I read the project description and understand the project clearly. I can guarantee you won't regret hiring me. Please feel free to ask any questions. Thank you!
€24 EUR 1日以内
4.9 (250 レビュー)
7.4
7.4
ユーザーアバター
Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
€25 EUR 1日以内
5.0 (290 レビュー)
7.1
7.1
ユーザーアバター
Hello, I have gone through your description and understood the requirements. I can do this job for you I can make this query work you have to get data before back slash and remove extra digits I can start your task right away. Thank YOu
€29 EUR 1日以内
5.0 (109 レビュー)
6.5
6.5
ユーザーアバター
As a senior web developer, I am very confident in mysql If you hire me, I will finish your project within few days. Please contact me and let's start our business. Best regards.
€29 EUR 1日以内
5.0 (16 レビュー)
6.2
6.2
ユーザーアバター
Hi, I would like to write the query to get the result in this pattern. Available for discussion and ready to start now. Regards, Manish
€15 EUR 1日以内
4.9 (125 レビュー)
6.2
6.2
ユーザーアバター
~~~~~~Check my following MySQL query~~~~~~ SELECT id, GROUP_CONCAT(res SEPARATOR ' ' ) AS result FROM (SELECT id, field1, lowcase, CONCAT(UPPER(SUBSTR(lowcase,1,1)),SUBSTR(lowcase,2, LENGTH(lowcase)-1)) res FROM( SELECT id, SUBSTRING_INDEX( SUBSTRING_INDEX(field1, ' ', n), ' ', -1 ) AS field1, LOWER(SUBSTRING_INDEX( SUBSTRING_INDEX(field1, ' ', n), ' ', -1 )) lowcase FROM tablea JOIN (SELECT 1 AS n UNION SELECT 2 AS n UNION SELECT 3 AS n UNION SELECT 4 AS n UNION SELECT 5 AS n UNION SELECT 6 AS n UNION SELECT 7 AS n UNION SELECT 8 AS n UNION SELECT 9 AS n UNION SELECT 10 AS n) numbers ON CHAR_LENGTH(field1) - CHAR_LENGTH(REPLACE(field1, ' ', '')) >= n - 1) tbl ORDER BY id ) tblB GROUP BY id
€23 EUR 1日以内
5.0 (38 レビュー)
6.0
6.0
ユーザーアバター
Hello, I am Oracle certified professional java programmer and have Bsc. IT. I work as Oracle techno functional consultant and also expert in oracle apex, please share more details so I may able to help you
€23 EUR 1日以内
5.0 (120 レビュー)
5.9
5.9
ユーザーアバター
Hello, Just contact me so I can provide You a ready mysql query to get results which You need. I'v already wrote a longer desc for Your previous project;) Regards
€13 EUR 1日以内
5.0 (28 レビュー)
5.4
5.4
ユーザーアバター
Dear Sir/Madam, Hope you are doing great!. I can surely assist you with my service in doing SQL query for you as per your above description. Looking forward your positive response. Best Regards, Ijaz Hussain
€50 EUR 0日以内
5.0 (22 レビュー)
5.3
5.3
ユーザーアバター
hi, use like in place of = and wildcard % to achive this. thanks. ...............................................................
€23 EUR 1日以内
5.0 (39 レビュー)
5.3
5.3
ユーザーアバター
Hello, I see that you need a query that selects data which starts with certain characters. Such query would look like: SELECT * FROM WWW_Stock_Cpnr_Winkel WHERE $changeable_variable LIKE "MKN198A005107M%" . Let me know if you find this working
€8 EUR 1日以内
5.0 (26 レビュー)
5.0
5.0
ユーザーアバター
Hi, Can you ping me to discuss more? I am interested in the project and want to do this project, Thanks
€14 EUR 1日以内
4.9 (46 レビュー)
5.0
5.0
ユーザーアバター
Hi,  I am a Full stack developer in Microsoft technologies.  My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (through stored procedures).  I have 6 years of experience as a full time software developer.  Kindly contact me, lets discuss your requirements.
€30 EUR 1日以内
4.8 (10 レビュー)
4.8
4.8
ユーザーアバター
Hi, my name is Esteban Salpeter and I'm an expert DB developer, with many years of experience on that platform. You can check out my portfolio to view some of my work. Your requirement is very clear, so the modifications can be done easily. I only must know in what DB are you working on to find the best solution for the code to be adaptive to artikel changes. Feel free to ask me any questions before contracting, I'll be glad to chat with you. Hoping to start working together soon, Best regards, Esteban
€12 EUR 1日以内
5.0 (10 レビュー)
4.5
4.5
ユーザーアバター
Hi i am expertise in i. Sql querying if u are interested ping me i will solve in an hour . I sont waste bith of us time so my bidding also based on my work
€19 EUR 1日以内
4.9 (17 レビュー)
4.4
4.4
ユーザーアバター
Dear client. I've read your project description carefully and very interested. Let's discuss over chat and get started. Waiting for your reply. Regards.
€30 EUR 1日以内
4.4 (23 レビュー)
4.6
4.6
ユーザーアバター
do it now NodeJs,Angularjs,MVC ,WCF,Entity Framwork,Canvasjs,Chessjs,Underscorejs,Angular Meterial,Ionic framework etc.
€10 EUR 1日以内
5.0 (15 レビュー)
3.3
3.3
ユーザーアバター
Hi, I have worked on same queries and I am providing you solution for your query. I was providing you query but you have deleted previous project so due to this I couldn't provide Now contact in chat I am providing working query. Thanks!
€8 EUR 0日以内
5.0 (3 レビュー)
2.7
2.7

クライアントについて

BELGIUMのフラグ
Kessel-Lo, Belgium
5.0
212
お支払い方法確認済み
メンバー登録日:4月 13, 2016

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。