Compare select statements sql oracleJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

... With some of the sharpest minds in psychology, marketing and finance we have developed a system that reduces waste and guarantees at least a 20 % increase in results. That might not sound like much, but ask any company if they would like to add 20 % on their bottom line with the same kind of expenditure, they would jump on that opportunity every day of the week. We have gathered a very select list of companies that would benefit grately from this kind of help and should have all the possibilities of achieving the kind of results guaranteed. It all boils down to your way of presenting, building trust and gently pushing them into a beneficial decision of accepting a very focused consultation. We want you to read this passage in Swedish and attach it to the bid. Only bid...

We're reaching out to find an ambitious Swedish copywriter to write sales focused and professional product information texts for a new e-commerce project. It's imperative that the person we select for the job has a proven record of producing high quality copy. The content produced will set the standard of our textual communication in terms of bringing out the quality and relevance of the products and ultimately forming the "right touch". Who you are You are motivated to engage our customers with your texts in an innovative and creative way. You make the reader feel involved. You understand and implement texts based on SEO requirements. You transform an already existing text to something unique and fun to read. You focus on the quality of the...

...subreddits: @rSlash As you can see he has just copied and pasted the original thread comment + other comments in the video. The total videos will be 10-20 minutes long. 1. User inputs link to subreddit --> scrapes everything 2. AI memorizes all the text in the tread 3. AI writes the script - a brief intro --> copies and pastes original post --> writes a brief transition statements --> copies and pastes the comments - making sure the flow makes sense and is interesting. 4. AI creates title options for the video. ChatGPT already kinda does this well (image below), but having trouble inputting large amounts of reddit and output longer text, and just trying to automate the process. Maybe there's a tool out there that can already do this out there? If you are able t...

Description: We are seeking an experienced Data Analyst to assist in a comprehensive market analysis project. The objective is to gather and analyze housing data to compare rental market trends in specific regions. This will help inform business decisions and strategies. Responsibilities: Collect housing data from multiple sources, ensuring all data is accurately gathered in compliance with all applicable laws and website terms of service. Analyze data related to rental amounts, property types, locations, and amenities. Provide detailed reports comparing market trends, prices, and available amenities. Create visualizations that clearly illustrate market dynamics. Requirements: Proven experience in data collection and analysis, particularly in real estate or similar markets. Stron...

I'm setting up a bike rental bus...business. The company will offer different types of bicycles such as mountain bikes, road bikes, and hybrid bikes. - The rental company will provide accessories like helmets and locks. - I need a professional who can create an online booking system for the bike rentals. The system should be integrated into our website. - This system should make it easy for customers to browse available bikes, select the ones they want to rent, choose any accessories they need, and make the payment. - The ideal candidate should have experience in e-commerce website development, with a specific focus on building booking systems. A background in the bike rental or similar industry would be a big plus. - I'm open to suggestions for the best approach to t...

I'm seeking a skilled professional to create a comprehensive loan statement on a...designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accounted for and calculations are accurate. I'm looking for a freelancer who can not only deliver on the technical requirements of this project but also has a good understanding of financial statements, particularly loan statements. Your ability to work accurately and efficiently is highly valued. Please provide examples of similar work yo...

I need a professional to create financial statements for my website in real-time. This should be presented in an interactive web dashboard. The ideal candidate should have experience in: - Financial statement preparation - Web development (dashboard creation) - Data visualization and incorporation of bar charts.

I need a very comprehensive method statement for a 155m2 construction project. I'll provide a sample, and you need ...construction project. I'll provide a sample, and you need to make sure the statement is detailed and well-structured. Key Requirements: - The method statement should be in a Word Document format. - It needs to cover all aspects of the project, with particular focus on the Excavation, Structural, and Finishing phases. Ideal Experience and Skills: - Previous experience in creating detailed method statements for construction projects. - Strong understanding of construction processes and terminology. - Proficiency in writing comprehensive content in a clear and structured manner. - Attention to detail is critical to ensure no steps are overlooked. Contact ...

...changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity with handling Excel files in a cloud environment will be particularly valued. Remember, the aim here is to create an automated system that ensures no changes go unnoticed, while avoiding constant email notifications. Your propos...

...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for accessing a...

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed wit...

I require a highly experienced assembler who can proficiently use Emu8086 to write and verify software programs. Though the details about the specific programs weren't provided, candidates should be skillful in at least the following areas: - Arithmetic operations - Control flow statements - File handling operations The purpose of these programs has yet to be confirmed, thus a candidate with a flexible approach who can rapidly adjust to altering requirements will be advantageous. This project is urgently required, hence a freelancer who can complete tasks promptly is desired. To confirm the validity of your work, you'll also need to test the developed programs and verify the correctness of your written code by initializing and checking relevant registers and memory locatio...

I'm looking for an expert digital artist who can alter an image to create a humorous bachelor party concept. Your task will be to perform face swapping and uniform modification to make it appear as if a particular person is donning JTAC gear. Key requirements: - Ability to select an appropriate photo for the edit - Proficiency in face swapping and image manipulation techniques - Experience in photo modification towards a military theme - Detail-oriented, ensuring the final photo appears professional Please note that it is a military-themed fun project, not intended for misuse. I encourage photoshop experts with a good sense of humour to place their bids!

I require a meticulous professional, experienced in the workings of Microsoft A...Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the software has t...

Se requiere un sistema diseñado en Python que trabaje en sistema operativo Wndows, el cual a través del uso del WebCam pueda hacer reconocimiento de rostros comparando el rostro en la cámara vs el rostro almacenado en formato digital en una base de datos en SQL Server 2016+. El resultados debe ser un True o False. El sistema debe trabajar localmente (No en la nube).

Mevcutta hibrit bir uygulamamız var. Sql üzerinden veri çeken bir servis mevcut Bu projeye rapor eklenecek

Preparation of complete sets of 2024 financial statements based on the required period.

I'm seeking a professional with expertise in financial documents, specifically balance sheets and profit & loss statements. - You'd be responsible for updating these documents with new figures - no structural or comprehensive changes required. - The modification will be minor, focused on figures and data. - Your role is to maintain the integrity of the documents while reflecting the new information accurately. Ideal candidates will have experience in: - Financial accounting, specifically with balance sheets and profit & loss statements. - Attention to detail, ensuring accuracy in the modification process. - Proficiency with financial software/tools would be an advantage. Your expertise in this area will be crucial to ensure our financial documents re...

...a folder structure on your computer to organize the images by product category (e.g., Shoes, T-Shirts, Sofas). Ensure you have a stable internet connection for browsing and downloading images. 2. Finding Images on Amazon: Go to Amazon. Search for a product category (e.g., "Men's Shoes"). Click on individual products to view their detailed pages. Select images that meet the quality and content requirements. Right-click on the image and select “Save Image As…” to download. Name the file appropriately (e.g., "") and save it in the corresponding folder. 3. Finding Images on Shopify: Go to Shopify. Browse through the "Examples" section or search for specific product categories. Click on stores or products that showcase...

This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants with su...

Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...

I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.

I'm looking to develop an on-demand service application that focuses on car services. Here are some key features I'm looking to include: - **User Registration and Login**: The app should have a smooth and secure user registration and login system. - **Service Provider Profiles**: It's important for users to be able to view and select service providers based on their profiles. - **Booking and Scheduling**: Users should be able to book appointments with service providers easily. - **Tracking**: It would be great if an in-app feature could allow users to track the status of their service requests. - ** Service Reminders: Automatic reminders for upcoming maintenance based on service history - ** Emergency Services: Provide options for emergency roadside assistance, such ...

I am seeking a professional writer who has experience in crafting personal statements, specifically for Pediatrics and Family Medicine Residency applications. The project involves helping me create a compelling personal statement that focuses on key qualities like compassion, empathy, leadership, and teamwork. Key Requirements: - Experience in writing personal statements for medical residency programs, particularly in Pediatrics , Family Medicine - Ability to highlight my compassion, empathy, leadership, and teamwork skills effectively - An understanding of what medical admissions officers look for in a personal statement - Excellent written communication skills - Previous experience or understanding of the medical field would be a plus I would appreciate a swift turnarou...

I have a simple powerbi poject. I have a dataset in excel based on which i need a table in the dashboard. I also require a filter to filter the rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can ...rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can be A, B, C or blank in those columns. user X had values A, B and blank in the columns A, B and C In this case if you filter the data using value A from the dropdown, it should show user X also if you select B. However if you select value C in the filter the user/row wil...

I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...

...dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you hav...

I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.

...expenses, and depreciation based on assumptions - Balance Sheet Projections:Project key items like working capital, fixed assets, debt, and equity based on historical ratios and expected changes. - Cash Flow Projections:Derive operating cash flow from projected income statements and balance sheet changes. Estimate capital expenditures and financing activities. - Dynamic Model: - Create a dynamic model in Excel, ensuring that changes in assumptions automatically update all related financial statements. - Assumptions Tab: - Develop a separate tab to document key assumptions, ( also can use screenshots with source link) including revenue growth rates, cost inflation, capital expenditure plans etc. 3. DCF Analysis: - Free Cash Flow (FCF) Calculati...

I'm in need of a website that can cater to new users and make scheduling appointments, managing user profiles, and processing payments an easy and seamless experience. Please go through figma file for detailed flow and screens of web needed. You can select react.js or any platform that will be easier for you.

I'm in need of an experienced application developer who can build a robust database application. The application will need to provide th...application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this remains to be finalized. However, skills in handling different types of data - textual, numeric and multimedia - will be considered an advantage. Understanding of standard SQL language, knowledge with various database systems and strong problem-solving skills will be ideal for this project. Strong knowledge of frontend and backend development with user interface design skills will also greatly contribute to our collabo...

Hi, I need to extract data from some sites and compare them in a unique database. In few words i need a scraping code in python that extract data from some sites and the data have to saved in a mysql database.

Hello, I want a development. I want a touchscreen interface to control a custom vending machine. I need someone who has already worked on the MDB protocol for payment. My request is that a customer can access a touchscreen with 2 to 8 pictures. He select a picture, it send via the MDB protocol the payment request and if payment is accepted it launch a small PLC siemens logo program. I need a manager interface to change the prices, the number of sales available for each product and the photo of the product. We will load at the beginning all the possible photos so no need to add photos in the user interface. I need to be able to access from a browser to basic informations (number of products available, last sales, temperature...)

...feature into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm looking for a ...

I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.

...on my corporation's yearly financial statements. The role involves: signing off on “Notice To Reader” for RBC financial statements - Financial Statement Review: You'll be responsible for thoroughly examining our financial records to ensure they accurately represent our corporation's financial position. - Regulatory Compliance: Understanding of Canadian financial regulations is essential to ensure our financial statements are compliant. - Communication: It's important that you can clearly communicate your findings and sign off on our statements in a timely manner. Ideal candidates should be: - Certified Accountants: You must be a certified accountant in Canada. - Experience in Corporate Accounting: Previous experience with c...

I'm looking for a talented developer to work on my existing music website. Key Requirements: - **Security Enhancements**: I need to bolster the site's defenses against hacking and ensure that the user login and authentication systems are rock solid. Ideal Skills and Experience: - Proficiency in Core PHP is a must, as the site is built on this technology. - ...background in web security, with experience in protecting sites against common vulnerabilities. See the attachment for details. Ask all of your questions in the discussion board so everyone knows the question and answer. Please do not submit a fake bid amount and completion time as that will disqualify you. We can discuss everything in the clarification board. We will communicate in chat after I select you as ...

Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with...

in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and...

...checkout for that product. 4. Disable shopping cart 5. Create one-page/multi-step ordering 6. Collection time slot selectable at ordering 7. Back end Visual calendar displaying orders by collection date 8. Calendar must sync with google calendar 9. Ability for staff to place orders on behalf of customers, with different payment options available only to staff members 10. Users able to select favorite products 11. User accounts to track user activity/store favorite products Further details, and screen grabs are provided as PDFs. To confirm that you have fully read the brief, please start your bid/reply with the word "Smile"...

...should also be able to see all of the invoices related to that Contract/PO. Also, the amount of the invoice should be deducted from the FundRemaining of the contract. Same if it’s a PO invoice. Also I should be process invoice if they are not related to a Contract/PO as well. As I mentioned, there should be an Approvers list, and when I am entering an invoice into database, I need a field to select the name of the person who approved the invoice. And when I go to the Approvers list, and click on a person name, all of the approved invoices by that person should be shown under their name/page. For Account Number, it should also be drop down list in the Add Invoice page, and searchable to easily find an account. Same with Accounts List page, when I open a specific account, ...