Sql query to find duplicate records in a column jobs

I’m seeking a web designer who can create my residential remodeling business. This website should clearly showcase my varied services, focusing on kitchen, bathroom, living room remodeling, room additions, and outdoor living areas. The style should blend modern, traditional, and contemporary elements, complementing our unique 'suburban barn' aesthetic. Ideal skills include: - Prior experience in creating portfolio websites for remodeling or similar industries. - Capacity to create a user-friendly interface, easy for potential clients to navigate to find service information. - An eye for design that can visually translate the varying styles of our work into an engaging and professional website. This project is a chanc...

We are currently experiencing significant performance issues with our Oracle database under heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best pra...

I'm looking for a skilled website designer to create a modern, user-friendly website for my beauty salon. The main aim of this project is to showcase our services and treatments in a visually appealing and organized manner. Key Requirements: - The website should be designed to effectively showcase our range of services and treatments. - It should include a detailed price list for our services. - The design should be modern, engaging, and suitable for the beauty industry. A clean, professional and elegant style is preferred. - It must be user-friendly and easy to navigate, ensuring visitors can quickly find the information they need. - It should have a Content Management System (CMS) that allows easy u...

...starting a project to develop a QR code payment application called "Metropol Pay" that will run on the Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed ...

We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Ext...

Please Sign Up or Login to see details.

...seeking an experienced accountant to assist in preparing and submitting our company's CT600 form. Ideal Skills/Experience: - Proven track record in successfully preparing and submitting CT600 forms - Proficient in UK tax regulations and ensuring compliance - Strong attention to detail to avoid errors The successful candidate will be responsible for: - Reviewing our financial records for the fiscal year ending on March 31st - Preparing and submitting our CT600 form accurately and in a timely manner - Ensuring that all tax obligations are met and that we comply with all relevant legislation It is imperative that you have a comprehensive understanding of the UK tax system and that you have successfully managed s...

As part of our company's pre-employment process, I'm seeking a skilled professional to conduct a thorough background check on potential candidates in Málaga, Spain. Key Components of Background Check: - Criminal Records: Verify if the candidate has any past criminal record that might be relevant to their role or our organization. - Credit History: Analyze the candidate's financial behavior and assess if it aligns with our company's standards. - Employment Verification: Validate the candidate's employment history to confirm the accuracy of their provided information. Key Aspects for Investigation: - Criminal Records: We need to ensure that the candidate doesn't have any criminal background...

Looking for someone to help create the promotional social media strategy for a new pop single. This would include developing the visual identity of the release and creating out of the box content ideas. To achieve this we would also need someone to analyse past releases and find specific points of improvement for the artists social media presence and content. Best, Joonas Management

I'm looking for a talented logo designer to work with me on creating a unique, eye-catching logo for my company. Key Elements and Colors: - I've attached detailed information about my company and the key symbols or elements that should be included in the logo. This will help you understand what my business is about and what I want to convey through my logo. - I've also included information on the colors I'd like to see in the logo. You'll find a mix of colors that I think are representative of the brand's values and personality. Skills and Experience: - Proven experience in logo design, with a strong portfolio of work that demonstrates your skills in creating unique, memorab...

I need assistance with my Wordpress site. I have a widget that appeared and i cannot find the source of it. This arrow will not go away. Watch this video:

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 serv...

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...

Focus Edumatics is seeking online tutors to join our growing freelance tutor community across Math, English, Language Arts, and Science. In this role, you will have the opportunity to closely collaborate with K-12 students in the United States, delivering personalized instruction, providing academic support, and creating a nurturing environment. Strong time management, problem-solving, technical proficiency, and exceptional English communication skills are essential for success in this position. COMPENSATION AND BENEFITS -- Rs 200 per completed session-hour. Earn Rs 40,000+ per month based on volume and performance. -- Training, retention, and performance-based bonuses based on quality, volume, and peak hour coverage. -- Teach from home with ...

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 looking for someone who can help me identify and find the owners of commercial properties in London. Key Responsibilities: - Research and identify owners of a specified list of commercial properties in London - Compile data on the owners and their contact information in a spreadsheet The ideal freelancer for this project would have: - Strong research skills, especially in identifying ownership of commercial properties - Experience in data entry and management, particularly in spreadsheet format - High level of accuracy and attention to detail - Excellent communication skills, as you may need to verify information Please provide a brief overview of your experience in identifying property ...

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

...officers who can help take my Extrusion Die Manufacturing business to the next level. Key Responsibilities: - Lead Generation: Your primary duty will be to find and attract potential clients in the technology and manufacturing sectors. - Sales Calls and Follow-ups: Once you've identified leads, you will be responsible for making initial sales calls and following up on leads. - Proposal and Contract Negotiation: Your role will also involve drafting proposals and negotiating contracts with potential clients. Ideal Candidate: - Previous Experience: A background in business development, especially in the manufacturing industry, will be highly beneficial. - Communication Skills: Strong verbal and written communication skills are a...

I'm currently facing a few issues with my Linux-based server infrastructure. These issues include slow performance, frequent downtime, and security breaches. I am looking to prioritize speed optimization as a primary focus for improvement. Few Days Work - Maybe One Day. Key Tasks: - Identify bottlenecks that are causing slow performance - Implement solutions to enhance server performance - Recommendations on security and downtime prevention Ideal Freelancer: - Proven experience in Linux server infrastructure maintenance - Proficient in diagnosing and resolving issues related to server performance - Familiarity with security measures for server systems - Reliable professional with a track record of improving server perfor...

I'm trying to find a Japanese voice actor who has done audiobook narration before. Adults are the intended audience, therefore the voice-over should have a soothing, tranquil tone. Important requirements include: - Fluency in Japanese - Prior voice-over experience, preferably in the audiobook industry - A peaceful, soothing tone of voice acting - An awareness of the subtleties and preferences of an adult audience The ideal applicant would be a skilled vocalist with a strong body of work. - Knowledge of the adult-targeted audiobook category in Japan - Experience producing audiobooks for the Japanese market

...expert wiki page creator to create a company page that mainly serves to provide information about our business. This page is aimed at other businesses, so a professional, trustworthy and sleek design is crucial. Key Aspects: - About Us Section: Detail our company history, product, services, contact etc.. - Services Offered: Comprehensive list and descriptions of our products/services. - Contact Information: Clear and easy-to-find contact details, including email, phone, and physical address. The ideal candidate for this job should have experience in corporate wiki page design, with a sharp eye for business-oriented aesthetics and functionality. Solid knowledge of SEO strategies, to ensure that atleast ensure that intent s...

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.

Global Sales Opportunity! Do you love food? Do you love sales? We're a Sri Lankan company crafting exquisite Ceylon cinnamon, tea, spices, and coffee – and we're seeking enthusiastic Sales Associates to collaborate with us in finding new wholesale buyers. What you'll do: 1. Find potential wholesale buyers in your region or target markets and build lasting relationships. 2. Discuss product details, ensuring buyers are informed and engaged. We'll provide all necessary resources and documentation to support you. 3. Facilitate seamless communication between buyers and our company. We handle shipping, banking, and cargo, so you can focus on sales. Why join us? 1. Lucrative Commission Structure: Enjoy generous commission...

...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...

I'm seeking a skilled Shopify designer and developer to enhance my existing Shopify website for my business. The primary focus will be on boosting the site's performance and ensuring a more seamless user experience. Key Project Goals: - Optimize loading speed: Currently, my website has a moderate loading speed, which is not ideal for ensuring a smooth and efficient user experience. I need the freelancer to improve this aspect significantly. - Enhance internal pages: I'm also looking for the revamping of internal pages. This includes making them more visually appealing and user-friendly. - Improve internal links: Moreover, I need someone who can enhance the internal navigation and links. This is crucial for ensuring visitors can e...

I browse to a text file containing a definition of a flowchart e.g. the intended flowchart is attached file It creates an image file of the flowchart. Simple example: See attached file The text file has 3 lines as follows: 1 circle 1.5 5.3,1.2 Begin 2 rectangle 6,2 5.3,2.5 Find node that represents the itemset 3 line 1,2 This file would mean to: 1: Draw a circle with radius 1.5 at point (5.3 across,1.2 down) with the word "Begin" in it. 2: Draw a rectangle with width 6 and height 2 at point (5.3 across,1.5 down) with the words "Find node that represents the itemset" in it. 3: Draw a line pointing from 1 to 2 I don't care how the definition works other than how general ...

As part of our company's pre-employment process, I'm seeking a skilled professional to conduct a thorough background check on potential candidates in Málaga, Spain. Key Components of Background Check: - Criminal Records: Verify if the candidate has any past criminal record that might be relevant to their role or our organization. - Credit History: Analyze the candidate's financial behavior and assess if it aligns with our company's standards. - Employment Verification: Validate the candidate's employment history to confirm the accuracy of their provided information. Key Aspects for Investigation: - Criminal Records: We need to ensure that the candidate doesn't have any criminal background...

The project is the automation of the process of downloading information from the page, organising the data, and include it in a normalised format specified in an Excel file. Duplicate records should be removed and uploaded to a shared repository. The instance of the software and the repository should be in AWS. It needs a user friendly run option. The scope of the service includes the configuration of a repository in a AWS, set-up a remote desktop , delivery of the source code with good development practices. Additionally to the neighbourhoods added in the file, the scraper mus include: Zone 2: Gran america Centro nariño Centro narino Puente aranda El recuerdo La florida...

I'm in need of a web-based multi SKU inventory software that primarily focuses on real-time inventory tracking. This software will be utilized by our warehouse staff to ensure products are correctly logged and easily retrievable. Key Features: - Real-time Inventory Tracking: The primary function of the system is to keep a close eye on the stock levels. - User-Friendly Interface: The software should be intuitive and easy to use for our warehouse staff. Integration: The system should have the capability to integrate with our accounting software. This is essential for keeping our financial records accurate and up-to-date. Ideal Skills and Experience: - Proven experience in developing inventory management software. -...

I'm seeking a skilled web developer to create a financial information website with features similar to forexfactory.com. The website will be designed with a modern and minimalist aesthetic. Key features include: - Live forums page: This will allow users to engage in financial discussions, share insights, and connect with other members of the community. - Economic calendar: We need a comprehensive economic calendar that notifies users of upcoming reports, events, and indicators that may impact the financial markets. We will need to find all the sources the main information comes from and scrape them using provided API's from the government sites that they provide usually. - SEC Insider Traders Page: This is ...

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on...

I'm in need of a data entry specialist to assist with cleaning up my text document data. Key Responsibilities: - Reviewing and identifying inconsistencies in the data - Removing duplicate entries if any - Correcting any errors in the data Ideal Skills: - Proficiency in data entry - Strong attention to detail - Ability to spot and correct inconsistencies - Experience in data cleaning from text documents Please Note: While specific data cleaning tasks are not listed here, the nature of the job is primarily to clean up the data, so a general understanding of data cleaning processes is required.

I need to find a skilled web developer for building a promotional website specifically targeting potential customers. The website would be largely multimedia-centric with a focus on images and videos showcasing the various aspects of my business. Requirements: - Proven experience in creating dynamic, multimedia-heavy websites - Understanding of how to optimize a website for promoting a business - High level proficiency with web design tools like Wordpress, Adobe Dreamweaver, and such. - Excellent graphic design skills for creating visually engaging multimedia content - Knowledge of SEO best practice to target potential customers effectively. Remember, the primary goal of this website is business promotion, specificall...

I'm looking for a skilled animator who can create a 2 in 1 video for the launch of a news analytics platform. The video will serve as both a countdown to the platform's unveiling and a narration of its key features. The target audience for this video is primarily business professionals. Key Points: - The video's style should be an animated explainer. This will help convey complex information in a visually engaging and easy-to-understand manner. - The tone of the narration should be conversational and engaging. It's crucial that the video captures the attention of the audience and keeps them interested throughout. Ideal Skills and Experience: - Proven experience in creating animated explainer ...

I'm looking for an exhaustive list of Australian gym owners, with a focus on capturing between 100 to 500 individual records. The data needed includes, but not limited to: - Owner's Email Address - Gym's Name - Gym's Website Ideal candidates for this job are experienced data miners and researchers. Having a good understanding of the Fitness industry would be beneficial. Strong attention to detail is paramount, ensuring accuracy in data collection and entry. Additionally, demonstrating respect for privacy laws and guidelines, including GDPR, is essential. Experience with spreadsheets and CRM systems would be advantageous. Gyms must be privately owned only, non franchise. Offer Personal Training. Boutique Exclude: Cat...

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 4 Send the new URL of the subpage change to the created group through the telegram machine

i looking for old silver thai coins (such as 1 baht coins from the 1800s and early 1900s and so on) and so i need a native thai person who lives in thailand, preferably bangkok, to find some reputable coin shops or people that sell genuine old thai silver coins, that are not fakes. i would also like to get some photos of some of the coins and their prices. the shops should have a good reputation as selling genuine coins, not fakes. i woud also like to know if they sell only ungraded coins or professionally graded coins, which are in plastic coin holders called slabs, which are plastic coin holders with a grade marked on them. so i would like : 1. identify good trustworthy coin shops or coin sellers that sell old thai coins (on...

I'm in need of a comprehensive spreadsheet tailored for managing preventative maintenance in a manufacturing setting. Key Features: Equipment Identification: Similar to a preventive maintenance schedule, start by listing all the equipment that requires maintenance. Include details such as equipment name, identification number, and location. Maintenance Tasks: List the specific maintenance tasks that need to be performed for each piece of equipment. This could include tasks such as inspection, cleaning, lubrication, calibration, and part replacements. Frequency of Maintenance: Specify how often each maintenance task needs to be performed. This could be based on factors like manufacturer recommendations, usage hours, or time in...

...looking for a creative and talented logo designer to help me create a logo for my youth program, "Summit Seekers Squad". The ideal candidate should be able to: - Translate the spirit of my program into a visually appealing design - Understand the color scheme of red and yellow - Incorporate the elements of a bold S logo, circled by hands into the design. - view examples and use them for specific inspiration It's a youth program for kids ages 6-18 that combined education, outdoors, and leadership. I have provided the font sample and logo sample along with colors and help me design a logo. I have given 2 specific S examples only use those or small variances of those logos Must have hands around i...

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

I am in need of a professional who can create a website that perfectly blends modern and traditional design elements, while focusing on providing an informative experience for my visitors. Key Features and Requirements: - The website is primarily informational in nature, so it must be designed with a user-friendly interface and clear navigation. User should be able to find product description using part number - Required to create a digital product catalogue that can also be downloaded as a PDF booklet - The design should be a seamless integration of modern and traditional styles, ensuring an appealing and unique look that stands out. - It is crucial to include product categories and filters, enabling vis...

NextGen is seeking an experienced IT professional or team to deploy a private email server on our internal infrastructure. The goal is to enhance security, ensure data privacy, reduce dependency on third-party email services, and customize the email system to meet our specific needs. The project will involve setting up the server, configuring DNS records, installing and configuring necessary software, securing the server, and ensuring seamless email access for all users. Key Deliverables: Infrastructure Setup: Set up a dedicated server or VPS with a static IP address. Configure necessary storage and network resources. DNS Configuration: Configure MX, SPF, DKIM, and DMARC records to direct email traffic to the server. ...

I'm in need of a logo for my upcoming record label, 9 Acres Records. It's a small project, but I'm looking for a high-quality, professional design that captures the essence of my label. Here are the key requirements for the logo design: - Name: 9 Acres Records - Color: Green Grass - Style: *Sketchs & examples attached* Font MUST be in OLD English font Ideal Skills and Experience: - Experience in logo design, particularly for the music industry - Ability to deliver a professional, eye-catching design - Creativity and willingness to collaborate on ideas - Excellent understanding of color theory - Strong communication skills to ensure we're aligned on the design I want this logo ...

I'm seeking a skilled developer to make specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a...

I'm looking for a creative designer to craft an engaging poster on the theme "When You Turn 18". The poster will be aimed at young adults and should raise awareness of the various laws that impact them. - The poster should be designed in an educational and informative manner, without focusing on any specific laws. - The aim is to encourage the target audience to access the online platform "When You Turn 18", where they can find detailed information about legal rights and responsibilities, financial independence, and educational opportunities. Should include a QR code to the online brochure. - The theme of the poster is related to adulthood and laws and must appeal to young adults as it will be a...

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that s...

I have an html form php file on my server. I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we nee...

I'm looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields.

...Scope" (I need you to do) 1. Initial Financial Statement Drafting (Basic Income Statement, Balance Sheet, change of Equity, and cash flow) as of 2024 March 31st (Year End 31-03-2024) 2. Maintain the company account and record transaction recorded (e.g: Journal Enters) 3. Recording and reconciliation of banking, AP, and AR transactions 4. prepare the accounting schedule (The “schedules”); A. Account Receivable, B. Account Payable, C. Payroll (Included MPF) D. Loan, E. Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you to do) 6. Using the accounting system "Odoo" for better recording pr...