How to find duplicate records in sql without group by jobs

I urgently need a specialist in Ubiquiti UniFi to help me revive my system, which has gone down following a power outage. I've been left without any internet connection and I desperately need a professional to come in and provide effective solutions ASAP. If you have experience in: - Setting up UniFi network - Troubleshooting UniFi network issues - Configuring UniFi devices and you're comfortable with dealing with various types of internet connections, as I'm unsure which one is used in my setup, your skill set is what I'm looking for. Your prompt help will be highly appreciated.

...video editor to help me enhance my YouTube videos. The ideal candidate should be able to bring my vision to life and ensure my content is engaging and appealing to my target audience. Key Requirements: - **Video Style**: I prefer a style that is educational and informative. The editor will need to understand how to pace the video, include relevant information, and use effective transitions. - **Incorporate Elements**: I would like the video to contain on-screen text and titles, animations or motion graphics, and fitting background music or sound effects. This will help make the content more engaging and visually appealing to viewers. Ideal Skills and Experience: - Proficient in video editing software, such as Adobe ...

...Gaming Keyboard Emulator Developer Project Overview: We are seeking a skilled developer to create a Windows-based keyboard emulator, specifically designed for gaming. The emulator must operate at a low system level to effectively mimic keyboard inputs for gaming purposes without requiring hardware. Key Requirements: OS Compatibility: The emulator should work exclusively on Windows systems. Emulation Focus: Aimed at simulating keyboard inputs for gaming applications. Ideal Skills and Experience: Proficient in Windows application development. Expert in low-level programming, specifically in system-level assembly language. Knowledgeable in gaming input emulation and keyboard input simulation. Experience in backend applications is b...

I'm in need of an experienced professional who can create a 60-second animated video ad for my company. The primary aim of this ad is to appeal to a business professional audience. Key aspects of the project include: - A 60-second duration: The video must be engaging and concise, delivering the brand message effectively within this timeframe. - Animated style: I'm looking for a visually appealing and creative animated video. This will require a skilled animator with a good understanding of business communication. - Audience-centric approach: The video should be tailored specifically for business professionals in terms of content, style, and tone. The ideal candidate for this project will have: - A strong portfolio of animated videos, preferably wit...

I'm looking to create a Facebook ad campaign to find a missing person last seen in a public space. This project calls for a strategic approach to deliver the message across all relevant audiences. Key requirements include: - Compelling Ad Copy: The ideal freelancer should have strong copywriting skills, able to craft engaging and compassionate text that effectively communicates the urgency of the situation. - Targeted Outreach: Experience in defining and reaching specific demographic groups on Facebook is key. They must optimise the campaign to maximise visibility, specifically for those located in the same area as the public space where the person was last seen. - Customer Engagement: They need abilities to han...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

I need a quick and concise service review. The task is simple and should only take five minutes of your time. Key Requirements: - The re...concise service review. The task is simple and should only take five minutes of your time. Key Requirements: - The review should be focused on the service specifically, without the need for comparing it against similar services. - I am looking for a moderate level of detail. While I don't need an in-depth analysis, I do want more than just a basic overview. Ideal Skills and Experience: - Experience in writing reviews, particularly service reviews. - Ability to provide a succinct yet informative assessment. - Attention to detail and the ability to adhere to a brief. Your review will be invaluabl...

I'm looking for a logo for my construction, home remodeling, and renovation business called Maison Stroi. I'm envisioning a minimalist design. We offer services like painting, bathroom remodeling, kitchen remodeling and more. The logo should be professional and elegant, without being overly intricate. Simplicity is key. Please note, I haven't specified any particular imagery to be included in the logo. This gives you creative freedom to design something that perfectly encapsulates the essence of a construction business in a minimalist and warm-toned way.

...experience in liqueur production. My interest is not limited to any particular brand; rather, I am seeking a comprehensive understanding on a broader scale. What You Are Expected To Deliver: - Compelling insights into overall production process of various liqueurs from a general perspective. - Suggestions, advice, or methods for improving production efficiency without compromising quality. As a qualified applicant, you should: - Hold a degree or certification in food sciences, chemistry, or related fields. - Have solid experience in the spirits industry, particularly in the production of liqueurs. - Show an understanding of scaling production processes. - Demonstrate adeptness at identifying and resolving production challenges effectiv...

I am looking for a skilled artist to create a unique heraldic image for me(you will be provided with references). Please look at my attached example for reference so you can see my expectation both in terms of style and complexity. If you are interested, please send examples of your previous work for consideration. (You will not be considered without submitting examples of your previous work, it is not my job to go to your profile and search) Compensation is $50 cad! If this is not enough, I completely understand, no one should be asked to do a job for pay they don't believe is enough. All I ask is you simply don't apply, and instead apply for the jobs that where the pay is agreeable to you.

Turkish Recording Project We have a project, that needs Native Turkish speakers, we will give you the text, and you need to record 110 short sentences. you just need to open the platform link, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 4$ for 110 short sentences record. 3. Payment after received feedback, It will take time 1-2 weeks. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

German Recording project We have a project, that needs Native German speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 8$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

...and AU to shoot a UGC video on how our product cleans your teeth. Here is an example: Here is our website: **Who we need based on our target audience:** - Female and Male between 35-44, (Mostly Female) - Mostly have a family and childrens or family oriented - Possibly a smoker or regular coffee drinker. **What we need:** - Make a Video about using our product for a few days using our scripts, you can come up with your own but basically we will provide everything. **From us:** - 50-70$ for a ready edited video 60 seconds long. (we can do the editing ourselves) - Our product you will keep and you can use it and save money for regular visits to the dentist

...Specialist will play a pivotal role in our operations, responsible for managing client accounts and sourcing materials from various platforms and suppliers. The ideal candidate will be fluent in English and have strong Mandarin skills, as a significant portion of our supplier base is located in China. They will have a strong background in mechanical engineering, sourcing, negotiating contracts, and coordinating logistics. Strong communication skills will be essential to effectively communicate client needs to suppliers and manage the end-to-end procurement process. Qualifications: 1. Proven experience in sourcing, procurement, and account management, ideally within the consumer electronics, manufacturing, or construction industry....

Italian Recording Project We have a project, that needs Native Italian speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 89 short sentences record. 4. The project will take about 10-15 mins only. Note : We need only Male speakers for this project. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

France French Recording Project We have a project, that needs Native France French speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

...developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this pro...

...a skilled designer to create and configure a Facebook Page for my business. The primary goal of this page is to generate leads among young and middle-aged adults. Key Points: - Aim: The main objective of this page is to drive lead generation. - Audience: The target audience for this page is young and middle-aged adults. Design elements should be tailored to this demographic. - Content: The content of the page will consist of text-based posts, images, and graphics. Please ensure the design is cohesive and engaging across all content types. Skills and Experience: - Proven track record in designing and configuring Facebook Pages, particularly those focused on lead generation. - Experience in creating designs that resonate with young and middle-a...

Entries without a cover image will not be considered! I want the entry image to be a screenshot of my profile with your work overlaid on the profile picture and cover image. Greetings talented designers! I am Catalin Tiriplic, a freelancer specializing in video editing and graphic design under the name DoofDesigne. We are looking to update our logo, profile image, and cover image for our online platforms. Requirements: Logo: Modern and professional, reflecting our creativity and professionalism in video editing. Clear, memorable, and representative of our services. Profile Image: Integration of the new logo. Abstract design or AI-generated artwork, without my photo. Cover Image: Design coherent with the logo and profile image. For...

I am l...Multivariate Test Effect Pillai's and Descriptive Statistics. what I need in this project is to explain for me how and why the calculation is done in this way in the paper that I will provide you later on so the statistic analysis is already done. I only need the explanation for my own understanding. So is there any possible way that we can conduct this explanation exercise today The target audience for this paper are academics and researchers, therefore, the tone and depth of the content should accommodate this group effectively. The ideal freelancer should have: - A strong background in Statistics - Excellent understanding and practice of Data Analysis techniques - Experience in academic writing - Proven ability...

...Twitter - Regularly update and manage my LinkedIn, Twitter, and Instagram accounts - Implement strategies to increase brand awareness and generate leads Ideal skills and experience: - Demonstrable prior experience in creating content for LinkedIn and Twitter - Proven track record of managing and growing social media accounts - Understanding of social media analytics and ability to leverage data for campaign improvement - Excellent communication skills and creative thinking to develop compelling content This project requires someone who can not only create engaging content but also understands the various nuances of different social media platforms. The successful candidate will be able to help me increase my brand's visibility and attract potent...

PLEASE READ THE ATTACHED DESIGN BRIEF! I'm seeking a talented logo designer to create a classic and elegant logo. I am using a competition so that I can find a talented designer to compelete the logo design. The aim is to have a logo that is not only visually appealing but also timeless and suitable for both online and print applications. I shall work with the best designers to make small changes before selecting the winning design. The winning designer will need to complete the design in web and print formats in pdf (vector), jpeg and ai. before receiving the prize money. Key Responsibilities: - Craft a classic and elegant logo that embodies our brand's essence as per the design brief attached - Ensure the logo is vers...

... The application is basically a blog with a few routes and simple pages. It uses backend API to fetch the data for articles. I want to deploy this app ideally to Vercel or Netlify. For SEO reasons, I want to use server-side rendering (SSR) so that user receives already rendered HTML and the API call is not necessary on the client. On the client, the app should hydrate so that it becomes interactive. The app is already working and when it is deployed without SSR, it works correctly. So you don't need to develop the app. You will need to configure the SSR in the project, configure the deployment location (Vercel or Netlify), and potentially adjust the existing JS code so that it works correctly in SSR environment (maybe...

Hello, I am Susan from FST Research group. We are organizing scientific conference on 27th May 2024 at hotel near Airport Schiphol, Amsterdam, Netherlands. For this we are looking for a conference coordinator, who can manage 20 participants. Responsibilities: 1. Providing conference kit, ID cards 2. Announcing program 3. coordinating with hotel team for services Requirements: 1. Must carry own laptop and help speakers to present their presentation 2. Prefer Amsterdam local candidates or very near to Amsterdam Benefits: 1. we will pay 100 USD for 8 hours event 2. will provide food including snacks and lunch buffets Best Regards Suhana

...a proficient developer to help me build a private API management console for the game Rust, using the Gportal private API. The core functions of the Console Rust Gportal Private API are mainly centered on player data retrieval, server status updates and server configuration management. Here's an overview of the project requirements: - You will be responsible for building a secure and user-friendly private API management console specifically for Rust, using the Gportal private API. - The system should allow for the retrieval of player data, server status updates, and server configuration management. - The UI should be intuitive and engaging, allowing for easy navigation and efficient use. - The system should be able to handle high volumes of data and requests wit...

I was trying to log into my Laravel application when I encountered the error 419. I need a skilled Laravel developer to help me review and fix session and token issues causing this error. When i loggin then succses then back that show 419 error Key requirements include: - Reviewing Laravel's default authentication and session management to identify the issue. - Fixing the session and token issues causing the error 419 specifically during the login process. Ideal candidates should: - Have extensive experience and understanding of Laravel's authentication and session management. - Be proficient in troubleshooting and resolving Laravel errors. - Be familiar with handling session and token issues in Laravel. Your goal will be to find...

I'm in need of a talented game designer who can create a 3D puzzle game suitable for adults on both Android and IOS platforms. Key Requirements: - **Game Type:** The ideal candidate should have a good grasp of designing puzzle games with a 3D interface. The game should be engaging and challenging, yet not overly complex. - **Target Audience:** The target demographic for this game is adults. I expect the freelancer to cater the game’s design, difficulty levels and overall gameplay to this age group. - **Graphical Quality:** The game should be designed with a 'cartoonish and simple' aesthetic. This means our target is a game that is visually pleasing but not overly complex or demanding on resources. Skills & Experience: - Experience ...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Ex...

Here is the text formatted as bullet points: - I am looking for a freelancer specializing in motion graphics design to create a marketing video for a legal company on TikTok. - The video should not exceed 30 seconds in duration. - The video should be in Arabic only. - The style should be cartoonish and include the following elements: - Icons - Characters - Text - The target audience is young people between the ages of 18 and 30. - The video must contain sound effects only, without music. - It should also include a voiceover in Arabic (AI-generated voices can be used). - and use this files - Please provide some examples of your previous work - The delivery time is only two days only .

I need a freelancer who can conduct a comprehensive background check for pre-employment purposes. The task involves: - Conducting a thorough check on the candidate's criminal records - Verifying the candidate's employment history - Confirming the candidate's educational qualifications The ideal freelancer for this project should be well-versed with background checks, have access to reliable databases and be able to compile the information accurately and efficiently. Please note that the privacy and confidentiality of the candidate's information is of utmost importance.

...Translating PDFs. The challenge here is to make sure that the translated content in the PDFs maintains the exact same format and layout as the original documents, without any alterations. Key Requirements: - Translate both scanned and text-based PDFs/images: I need a professional who can handle both types of documents with equal proficiency. - Language Proficiency: The translation will be from English to a variety of languages. Your ability to work with any language from a dropdown menu is crucial. - High Accuracy: The translated content must retain the original meaning and context with 95+% accuracy. Ideal Skills and Experience: - Proficient in Python: You should have extensive experience using Python, along with any relevant libraries or ...

...alterations. The primary tasks include changing the company name and updating contact information. Your expertise in both text editing and formatting is crucial for this project. Key Tasks: - Change company name: The new name should be seamlessly integrated into the document, replacing the existing one. - Update contact information: The current contact details in the document need to be replaced with the new information provided. Skills and Experience Required: - Proficiency in PDF editing: Experience with editing text in scanned PDFs is necessary, as the document is not in its original format. - Attention to detail: It's essential that the changes are made accurately without affecting other parts of the document. - Familiar...

...encountered a sudden booting issue with my AlmaLinux system. The problem began without any known cause and now the system displays filesystem errors during the boot process. I am seeking a proficient freelancer to help me resolve this problem promptly. Ideal candidates for this project should have: - Expertise in Linux systems, especially AlmaLinux - Experience troubleshooting and resolving sudden booting issues - Proficiency in identifying and rectifying filesystem errors Your role will involve: - Diagnosing the sudden boot issue on my AlmaLinux system - Fixing the filesystem errors that are occurring during the boot process - Ensuring that the system can boot successfully without any errors I look forward to working with a skilled freelan...

I have a one-page press release written in English that need to be accurately translated to German. The goal is to have them localized for a German-speaking audience without losing the professional and formal tone of the source material. BUT I need it done this morning! Key Points: - The project involves translating marketing materials, so experience in this specific type of translation is preferred. - The tone of the documents is formal and professional and must be maintained throughout the translation. - The ideal candidate would have a strong command of both English and German, with a proven track record of delivering high-quality translations for business purposes.

I need a freelancer to convert my PDF file to a Word file using Word 2016. I'm looking for someone who can efficiently convert my PDF file into a Word document. The successful freelancer should: - Use Word 2016 (or newer) for the conversion - Ensure the document is accurately converted without any alterations to the original information - Possess strong attention to detail to ensure no information is lost or altered during the conversion Please include a detailed project proposal with your application.

Russian Recording Project We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 761 sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $20 dollar for 761 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

I am in search of a proficient writer to develop a book targeted at novice teachers. The central theme revolves around teacher empowerment. The selected writer should be able to present concepts in an inspirational and motivational style. Focussing on early years - Image of the child, relationship between educators, families, children and communities, rights of children and inclusive and democratic learning style Key Responsibilities: - Break down complex empowerment strategies into simple, actionable steps. - Use compelling and motivational language to inspire new teachers in their journey. Ideal Skills: - Proven experience writing in an inspirational and motivational style. - Familiarity with the field of education, specifically teacher ...

In need of a skilled professional to develop a RESTful API using Python. The API should be designed to handle multimedia data. Ideal Expertise: - Proficient in Python programming. - Thorough experience in RESTful API development. - Should specifically be adept in dealing with multimedia data handling. - Great problem-solving skills. - Conduct testing ensuring optimization and compatibility. Transparency, communication, and attention to detail will be crucial for this role. A fast turnaround will be appreciated without compromising on quality. If you have what it takes to handle this job, I welcome you to make your bid.

I'm in need of a highly skilled and advanced CISSP trainer for on-prem training in Kuwait. The training will be for a small group of 1-10 participants. The ideal candidate should be able to provide the following training materials: - Comprehensive printed manuals and handouts - Digital copies (PDFs, slides) for participants to refer to post-training - Practice exams and quizzes to help reinforce learning and assess understanding The trainer will be expected to travel to Kuwait for this assignment. Experience in providing CISSP training in a physical setting, particularly in the Middle East, would be a significant advantage. The ideal candidate should be able to deliver complex CISSP concepts ...

Music Video Production Pre Production: Location scouting Production: 2x Locations Post Production: Basic edits with music. Price : US$2000 Payment milestones $500 to be paid as a token for confirmation. $750 to be paid on the shoot day. $750 to be paid upon confirming final draft. Please note, final video without watermark will be uploaded only upon receiving full payment.

I'm urgently in need of a software developer who can help me fix some bugs in my software and make some necessary adjustments to the code. Key Requirements: - Debugging: You should be experienced in identifying and resolving bugs in software. - Code Customization: The project may require some customization of the code to ensure it meets my requirements. Your experience with software development, particularly with Java, Python or C++, will be highly regarded. The project is quite urgent, so I'm looking for someone who can start immediately and deliver fast, but without compromising the quality of the work.

I am in need of a skilled architect experienced in maximizing space utilization for a renovation project. I have two key areas in my residential property that require attention: - Living Room: I'm seeking creative solutions to better utilize the current space. - Bedroom: I need innovative designs to optimize the available space. - Bathrooms - I need ideas on how to make the bathrooms stylish I also need to find space to have a desk for home office. Finally I would need somone able to provide a light design Ideal skills for this job would include: - Proficiency in renovation architecture - Experience with residential projects - Strong understanding of space optimization techniques - Expertise i...

...media and community manager to help me revive a Facebook group that's been quite dormant. My primary goal is to significantly increase the group's membership, specifically targeting professionals in a specific industry. The group is here and I want nore trades people electricians, plumbers, centrao heating engineers Key Responsibilities: - Develop and implement a strategic plan to boost group activity and member engagement. - Create and schedule relevant and engaging posts to attract new members. - Initiate and moderate discussions to foster a sense of community among current and potential members. - Utilize various growth hacking techniques and strategies to expand the group's reach within the targe...

I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion is to extract text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining formatting ...

I require the expertise of a proficient Odoo ERP freelancer to assist in migrating data from an old system to a new one. Key Requirements: - Expertise with Odoo version 15. Familiarity with the ins and outs of this system version is crucial to successfully migrate the data without loss or corruption. - Extensive experience is paramount. I'm eager to hear about the similar data migration projects you've handled in the past and the results you've achieved. - A deep understanding of the Accounting module which the data is primarily focused on. Ensure you are adept at dealing with figures, financial data, balance sheets and other financial reports. Best suited freelancers would be detail-oriented, meticulous, and possess a pr...

...video aimed at parents. The primary goal of this project is to grow awareness about a specific product, and it's essential that the writer can connect with the target audience on a deep, meaningful level. Key project deliverables: - High-quality, compelling copy for the video ad script in Hindi - Engaging content that highlights product features and benefits - An emotional connection with parents in the viewer's group Ideal candidate skills and experience: - Proven experience in writing video ad copies - Ability to write persuasive, meaningful, and relatable content for parents - Comprehensive understanding of marketing and advertising strategies - Excellent communication and conceptual thinking abilities. I look forward ...

...converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table

I'm looking for an experienced hacker who specializes in database scraping to assist with lead generation. My main aim is to get detailed contacts to grow my business. - Specific Tasks: - Database scraping - Extract contact details - Contact Information: - Email addresses - Phone numbers Ideal candidates should have previous experience in the field. Proficiency in data mining and scraping is a must, along with an understanding of lead generation strategies. Strong grips and successful track records on obtaining accurate contact details are key to perform this job efficiently.

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.