How to eliminate duplicate rows in sql without using distinctроботи

Необхідно розробити веб-застосунок та описати його роботу. Опис має бути в форматі одного розділу бакалаврської дипломної роботи. Більш детальний опис наведений в закріплених файлах.

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.

...Супроводження процесу впровадження. Вимоги: • Досвід роботи – від 2-х років. • C++11, STL, GCC/CLang, GDB/LLDB, GNU Make, CMake, Bash. • Знання STL — контейнерів та алгоритмів. • Знання файлового вводу/виводу у стандарті POSIX. • Знання POSIX Threads —нитки, м’ютекси, умовні змінні. • Вміння користуватися системою контроля версій Git. • Вміння користуватися командним рядком Linux. • Реляциійні БД, SQL. • Основи функціонування комп’ютерних мереж, протоколи TCP и HTTP. Знання HTTP/1.1. Знанння архитектури REST. • Багатопоточність. Буде плюсом: • C++14, 17, 20. • Qt. • Boost. • Засоби статичного і и динамічного анализа коду (cppcheck, clang-tidy, clazy, valgrind, gprof, &helli...

... Шукає Unity розробника для створення багатокористувацької браузерної 3D гри, Unity за допомогою WebGL. Обов'язкові навички: Вміння працювати в Unity і знання мови C#. Плюсом буде додаткові знання: JS, HTML 5. І back end розробника для написання серверної частини на ASP.NET Core. Обов'язкові навички: ASP.NET Core Entity framework core SQL С кидайте свої резьуме на: business@ або проджект менеджеру проекту: viktorstor@ KICKOOS GAMES - це молода outsourc GameDev компанія, що з недавна почала розробляти і внутрішні проекти. Друзі компанія зараз розширюється і влітку планує відкрити офіс в Україні, тому долучайтеся до нашої спільноти у телеграмі, де публікуются відкриті вакансії на різні позиції.

...без додаткових зусиль користувача який буде їх проходити. -------------------- Need to develop several tests. Tests must have three levels of difficulty and a demo version (introduction). The demo version don’t have time to complete the task and shows the correct answer when passing the test stage. At the end of the test, the final result is displayed with the answers and the width percentage of correct answers. I add examples with tests in the video. The developed tests should be as close as possible to the given example (all examples, conditions and correct answers will be provided). In the future, the tests will be used on the site, so it must be integrated and run into the body of the site, without additional effort of the user w...

Write a blog in English with 3500 characters without spaces.

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'

We need to make online store like: , Without content. Also useful filters for specific product characteristics. need online chat Потрібно зробити інтернет магазин на зразок: Без наповнення. Також потрібні фільтри товару за певними характеристиками, онлайн чат

Creating a map element without using the Bubble map plugin with map display in 2D.

I'm in need of a CSS specialist who can meticulously recreate a graphic using CSS, ensuring the appearance and effects remain consistent across different devices and browsers. Expectations: - Recreate the graphic involving rings/circles, focusing on replicating the gradient color, glow/light shadows/neon effect, and depth. - The placement of rings/circles doesn't need to be identical to the reference image, but the overall look and effects must be maintained. Key Requirements: - Strong CSS skills with a proven track record in creating visually appealing and interactive designs. - Familiarity with various CSS effects, particularly gradient colors, glow, and depth. - Ability to ensure compatibility and responsiveness across different bro...

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has ...

...live broadcast, introduce the game you are playing to the audience. Live broadcast platform: Kwai platform Live time: Live broadcast time: 7:00-10:00 in the evening local time in Brazil, two hours of continuous broadcast every day. Rest: 4 days off a month. Basic requirements： computer equipment and Internet in Portuguese (and preferably in English) and cheerful the face live Job salary: Fixed part: 2 hours of live broadcast every day, 10 US dollars per hour. If you are willing to broadcast for a third hour, the hourly wage for the third hour is $5. Commission part: During the live broadcast, you will get a commission by downloading games or paying for games in the live broadcast room. Due to the diversity of live bro...

...Nest Living. I'm open to any colour scheme, so feel free to be creative. Key requirements: - Professional: The logo should reflect a sense of experience, trustworthiness and credibility. This should be conveyed through the choice of fonts, symbols and overall design. - Modern: The logo should have a contemporary feel, avoiding dated or overly traditional design elements. - Elegant: I want the logo to have a touch of sophistication and refinement. It should be stylish and classy, without being too flashy. - The company name must be included in the logo Ideal skills and experience: - A strong portfolio with a history of successful logo designs, particularly for professional services or real estate businesses. - Up-to-date knowledge of des...

Need someone to create Php script that can be used to create domain and subdomain using cpanel api

...processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants from a third image. Ideal Skills and Experience: - Proficiency in image processing algorithms and techniques. - Familiarity with AI te...

I'm seeking a skilled professional to duplicate an existing website with identical content, while implementing a completely new branding. The new branding will involve changing the logo, color scheme, typography, and all visual elements. Additionally, I need the duplicated website to include a contact form and a blog section. Ideal candidates for this project should have: - Proven experience in website duplication - Strong understanding of branding principles - A portfolio demonstrating successful website rebranding projects - Proficient in HTML, CSS, and JavaScript to handle the additional features - Excellent communication skills to ensure the new branding aligns with our brand guidelines This project is an exciting opportunity...

...seeking a skilled freelancer to help me connect them for a home automation project. Key Responsibilities: - Implement a system that can control lighting, monitor temperature and provide security surveillance - Ensure the system can be powered using solar, wind, battery and be connected to the internet. The ideal candidate should have experience in: - Arduino and BBC Micro:bit programming - Home Automation projects - Solar and wind energy integration - Internet of Things (IoT) connectivity - Strong understanding of security surveillance systems Your role will involve setting up a reliable, efficient and user-friendly home automation system. The ability to integrate multiple power sources and ensure the system is internet-connected is important. My g...

I'm looking for a skilled developer to create a web-based basic arithmetic calculator. Primary Functions: - The calculator should perform basic arithmetic operations such as addition, subtraction, multiplication, and division. Key Features: - The calculator should have a clean and user-friendly interface. - A history feature is optional, if you can integrate it seamlessly without compromising the simplicity of the calculator, that would be a plus. Ideal Skills: - Proficient in web development, particularly in developing interactive and user-friendly interfaces. - Prior experience in building calculators or similar tools is a big plus. - Strong understanding of basic arithmetic operations and their implementation in code. This is a great ...

I'm looking for a legal professional with experience in drafting contracts, specifically wholesale distribution agreements. Your task will involve: - Defining the rights and obligations of all concerned parties, to maintain clarity and avoid any potential disputes in our business relationship. - Including key terms in the agreement like a termination clause, an exclusivity clause, and a liability clause in order to secure our company's interests and limit potential risks. - Providing an open-ended duration without any specific term limit, allowing for indefinite continuation until either party chooses to terminate. This is a vital document for our business, so accuracy, attention to detail, and knowledge of co...

...Initiative based in Uganda, dedicated to uplifting underprivileged children through education. Today, I'm reaching out to you with a heartfelt plea to support three remarkable children - Alice Alyeko, Ben Otim, and Emma Mukutu - in their educational journey. Education has always been my passion and driving force. Growing up in Uganda, I witnessed firsthand the transformative power of education in breaking the cycle of poverty and empowering individuals to create better lives for themselves and their communities. It's this belief that led me to establish the Awuor Support Initiative, aiming to provide equal educational opportunities to children who are often overlooked and underserved. Donate here ...

SEO Audit tool need to make using google lighthouse Hello, 1, We want to make an SEO audit tool, by the help of integrating the google lighthouse to generate an SEO Audit report. Here is a link to how you can do it. Here is an example how these people have integrated and using google lighthouse to generate reports. We need exactly the same. 2, need an admin panel where admin can add or import the list of the website url,and website owner name , number and email address. So report can generated by the system and keep sending the email pdf report to the owner of the website like its work in front side for this site

I'm in need of a creative writer to come up with "Would You Rather" jokes for a middle school audience. The jokes should: - Be suitable for middle school students. - Be delivered in written form, without the need for illustrations or audio. - not IA generated - not from internet or from existing books (sorry, we already have them all) Ideal candidates for this project are: - Experienced writers or joke creators who understand the unique sense of humor of middle schoolers. - Able to produce engaging and fun content that is suitable for kids/family party. - Creative and able to come up with a wide range of jokes on different everyday topics. Your work will help entertain and engage our young listeners and must respect the target a...

Hello, I'm looking for a professional developer who can create an app for Android camera that can receive live video streams from OBS and broadcast them directly onto the primary screen of the smartphone's camera. The app should be able to convert the stream sent from OBS into a format compatible with the phone's primary camera and display it in high quality. The app should be capable of playing the video directly without the need for an external application, but I need a skilled developer with experience in integrating with OBS and efficiently programming the app. The app should be compatible with the latest versions of the Android operating system. Please provide a detailed quote along with a timeline for delivery if interested. Thank you.

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

I'm in need of a modern, minimalistic logo for my Ecommerce Store, Play Zone 24 (We sell toys on online shop). I'm open to your creativity regarding the color scheme - as long as the logo looks good, I'm happy. Key Requirements: - Modern and Minimalistic Design: The logo should be sleek, simple, and contemporary. - Professional and Polished: It represents a company, so it should look professional. - Creativity: I'm looking for a unique and original design, not something generic or overused. Your Skills: - Experience in Graphic Design: Proven experience in logo design, preferably with a modern and minimalistic style. - Creativity and Originality: A distinct style that sets you apart from other designers. Please submit your portfo...

...can deliver top-notch technical solutions to improve our system. The project is urgent and needs to be completed ASAP. Key Requirements: - Customization of Sales & CRM, Payroll, Project task management, HR modules: We are looking for someone to tailor these modules to our business needs, ensuring they function optimally. - Seamless integration with erpnext: We need the developer to integrate our system with erpnext seamlessly, without any disruptions in our current workflows. The ideal freelancer for this job would have: - Proficient in ERPnext: Experience working on ERPnext projects and a deep understanding of its functionality. - Integration Skills: Capable of integrating systems smoothly and efficiently. - Urgency: Able ...

...editor to accurately insert a person from a given photo into a distinct group photo. I require precise merging skills to blend the person naturally into the intended image. Specifics Include: - I do possess both the images that need to be worked upon. - The critical change is to incorporate an individual from one picture into a group photo in an unnoticeable and flawless technique. - I want the person from the first image to be precisely positioned next to a specific individual in the group photograph. The ideal freelancer for this project must have extensive experience in photoshop or equivalent photo editing software, a keen eye for detail, and a strong understanding of lighting and shading to match the ad...

Skills require...securely. Authentication: OAuth for handling secure authentication with streaming services. Technical Requirements and Development 1. Secure Authentication: Implement OAuth or a similar secure authentication protocol to allow users to log into their streaming services without storing their credentials. 2. Device Management: Develop a system to manage devices that can stream content, ensuring only authorized users can access the services during their stay. 3. Session Management: Ensure that user sessions are automatically ended upon checkout, or provide a simple way for users to log out when they are done watching. 4. Privacy and Security: Since the app will handle sensitive login information, ensure that the data is protected through en...

We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.

We filmed a short PSA and trying to see how possible it is to take the character out of the final shot. Attached is the frame. We would just need a still image so you wouldn't be masking him out in the video. The trick would be could you make it look like we filmed it without him there.

Fixed cost & developers from Uttar Pradesh only . I'm looking for a skilled freelancer who can help me develop a real-time temperature display system using NodeMCU ESP8266. Key Project Requirements: - Integration with 3 or more Bluetooth BLE sensors - Real-time temperature display on an LCD screen - Parsing advertisement data from nearby paired BLE sensors - Data sheet will be supplied for reference Ideal Skills/Experiences: - Proficient in programming with NodeMCU ESP8266 - Experienced in working with Bluetooth Low Energy (BLE) technology - Familiarity with parsing advertisement data - Knowledge of connecting and operating LCD displays This is a fixed cost project with a budget under $100. Please provide your quote for the project, along with your relev...

I have a set of handwritten documents that are moderately clear and need to be typed out without any changes in the format. I am looking for an experienced typist or data entry specialist for this project. The successful candidate should: - Have a strong proficiency in English - Be able to decipher moderately clear handwriting - Be patient and detail-oriented The task is to accurately transcribe the content of the handwritten pages into a digital document, without any alterations in the layout. Your responsibility is to provide me with a neatly typed, error-free version of the original handwritten text. Please note that the quality of the output will be checked against the original, hence, accuracy is paramount.

...a talented fashion designer to create a modern hijab design. The key characteristics that should define this piece are: - Modern Style: I'm looking for contemporary designs that will be relevamt in today's fashion world without clashing with the purpose of earthiness and spiritual connection. - Minimalistic Patterns: Please keep the design simple yet captivating. The patterns should be kept to a minimum, focusing on the structure and overall appeal of the hijab. - Pastel Colors: I prefer colors on the softer side. Light pink, baby blue, and soft peach are some examples to consider. Ideal candidates for this project should have experience in fashion design, particularly in creating designs for scarves or similar accessories. Ab...

I need a PHP script to update an existing PDF file with data from a form. - The purpose is to update information in the PDF file, not generate new ones. - The edited PDF will be displayed once, not saved for future reference. - The data that I'll be entering into the form is a bit more complex than just text. It includes text, images, tables, etc. The ideal freelancer for this project should have: - Strong understanding of PHP. - Experience with PDF manipulation in PHP. - Ability to work with various data types in PDFs. - Attention to detail to ensure the PDF retains its original style, font, spacing, etc.

...Agency are in need of an experienced community moderator for our client's Discord, Telegram, and Reddit platforms. This role will include a range of tasks such as: Discord: - Deleting inappropriate messages. - Managing user conflicts. - Enforcing server rules. - Building and maintaining an engaging server environment. Telegram: - Monitoring chat activity and ensuring user's compliance with community guidelines. - Identifying and removing spammers. - Managing user bans efficiently without disrupting the positive community vibe. - Providing guidance to users, addressing their queries, and enhancing their platform experience. Ideal candidates should have prior experience managing these platforms and have great conflict resolution and community management s...

Hi Hossein, I enjoyed our phone call and clearly you know what you are doing. I like your idea of producing a cloned Vue 3 component that received the same input variables as the existing component, that is a _child_ of the existing component. That way you can do the development of the new component, without interfering with existing functionality. I would like you to implement this for me in my app as proof-of-principle. I know you are busy with multiple projects so I am flexible on timing. Best wishes, Darrel

many lesson slides similar to power point created for spelling and reading

...talented UX/UI designer to create a simple mobile app. The main function of the app is to receive notifications, similar to emails or SMS. A total of 12 layouts need to be designed. The logo and colors are already finalized, and there is an existing old design in Figma. Requirements: Experience: Proven experience in UX/UI design for mobile apps. Design: Simple, intuitive, and user-friendly layouts based on the existing Figma design. Compatibility: Designs should be suitable for both iOS and Android. Components: The layouts must include all necessary components for notifications, such as: Sender logo Sender verification status Timestamp formatting Title and short description of the notification Notification category Required Layouts: 1. Splash...

We are looking for a 60-second video that will be used to introduce an online course about diamond jewellery in MasterClass style. The video needs to be created in an inspirational and motivational style to engage the viewer and create a sense of excitement. See examples here: You can use stock video content from sites like: Key Requirements: - Create a 60-second video - Target audience: Young adults (18-34) - Style: Inspirational and motivational Ideal Skills: - Video production - Creative direction - Understanding of young adult audience psychology Experience: - Prior work on similar product introduction videos - Experience creating inspirational or motivational content - Proven track record of engaging young

I have a black-colored, cotton garment that I want to change to white. I'm looking for an experienced professional who can accomplish this without damaging the item's quality and texture. The ideal freelancer will have prior experience with fabric dyeing, color theory, and material handling. Knowledge of best practices for color transition for cotton materials is a must.

...LAST)))I won't respond to any bids unnecessarily. Second, you will only bid when you have applied my complete requirements to your localhost and have the project ready. Complete the work and then bid. Writing that I did it and , I will understand. Then I will understand and give login access you to my hosting, and your job and its price will be fixed at $25. I won't reply to anyone's bid; I've already wasted a lot of time. Whoever wants to work can create the same product page on their own and bid. I'll talk then, otherwise not. I'm looking for a skilled WordPress developer : I only need one page. It must have a product that functions like this one: I need same website landing page but just to reiterate, the func...

...the boot sequence completes. This issue arose without any identifiable trigger, as I was not involved in any software installations or system updates immediately prior. I'm looking for an expert to diagnose and resolve this problem. Key Tasks: - Diagnose the cause of the crash - Implement a solution to prevent future crashes - Provide any necessary documentation/troubleshooting steps for future reference Ideal Skills and Experience: - Proficient in Ubuntu 20.04 system administration - Experience in diagnosing and resolving system crashes - Strong troubleshooting and problem-solving skills - Excellent communication to provide clear documentation and explanations The ultimate outcome from this project is for the Ubuntu system to...

I'm in need of a well-designed Self-Defense Training Dummy specifically for martial arts training purposes. Key Features: - Durability for Repeated Use: The dummy should be able to withstand consistent training sessions without any damage. - Realistic Joint Movement: The arms and legs should be able to move naturally, offering a realistic experience for the practitioner. The ideal freelancer for this project should have experience in: - Industrial design, specifically in creating training equipment. - Knowledge of martial arts or experience with designing related products. - Ability to deliver a durable and realistic product.

...talented graphic designer to create an engaging wall vinyl design for a juice, shake and cafe shop. Key Project Requirements: - Theme: The theme or concept for the design is yet to be decided. It's an open canvas for your creativity. - Specific Elements: The design should include elements like fruits, shakes, burger, sandwich, glass, etc. These are the core items in our offerings and should be well represented. - Colors: The design should be inspired by the vibrant colors of various juices, creating an attractive and lively atmosphere. Ideal Candidate: - Experienced graphic designer with a strong portfolio of similar works. - Skilled in creating captivating and cohesive designs without a strict theme. - Familiar with designing for commercial s...

I am in need of a logo design for my brand of Kickboxing / K1 shows, "War on the Shore". We have an existing brand identity (attached), so this name must be incorporated into the design somehow. The ideal freelancer for this job should have: - Proven experience in logo design - Ability to create a design that is not only modern but also able to reflect the brand's identity - Good communication skills to understand my vision for the brand. This is vital. Please include some of your past works in your proposal, any applications without will be ignored. I'm looking forward to your bids.

I'm seeking a freelancer to develop a custom web scraping script. The goal is to curate a comprehensive database of restoration and IICRC technicians in Australia. Specifically, I need the following information from their websites: - Business name - Phone number - Email address - Location (state, suburb, postcode) Websites without data available to scapers will require manual collection The ideal candidate should be well-versed in web scraping, particularly with experience in extracting data from websites into an organised and structured format. You should also possess strong problem-solving skills to handle any complications that may arise during the scraping process. This is a specialised type of cleaning so the database sh...

I'm looking for a talented data analyst to help me leverage MIRO for a deep dive into our various types of data and generate actionable insights. I need the work done quickly, so please be prepared to jump right in. Key skills and experience required: - Previous experience in data analytics, particularly using MIRO and analyzing a range of data sources. - Ability to identify trends and patterns, discover correlations between variables, and make data-driven recommendations. - Excellent communication skills and the ability to present complex findings in a clear, understandable manner. - A proactive and fast-paced work ethic- the ability to deliver quality work quickly, without compromising on accuracy.

We are seeking a talented and creative packaging designer to create approximately 8 unique designs for our incense sticks boxes. Each design will reflect a distinct theme based on the name of the product. We have established design ideologies to guide the aesthetic and conceptual direction, and we are looking for a designer who can bring these ideas to life with innovation and artistic flair. Project Details: Product: Incense Sticks Number of Designs: 8 Design Themes: Each box design will be inspired by the specific name of the incense product. For example, a product named "Zen Garden" may have a serene, nature-inspired design, while "Mystic Night" might feature a darker, more mysterious theme. Design Ideologies: Our design ideologies encom...

I'm in need of a creative and skilled graphic designer to create a consistent, modern and vibrant stationery set for my business. Key requirements: - Design of Business Cards, Letterheads, Envelopes, and Email Signatures. - Modern and sleek style. - Incorporation of an existing logo, without any pre-established brand colors. Your role will be to take the logo I provide and build a complete set of stationery that embodies a modern aesthetic. The design should be professional and suitable for use in a variety of business contexts. Ideal skills and experience: - Proficiency in graphic design and stationery design. - Strong understanding of modern design aesthetics. - Ability to create a cohesive set of stationery items. - Experience ...