Knex subqueryemplois

Filtrer

Mes recherches récentes
Filtrer par :
Budget
à
à
à
Type
Compétences
Langues
    État du travail
    137 knex subquery travaux trouvés au tarif de EUR

    We're looking for a Full-Stack Engineer to join our team! We're using - Vue / [se connecter pour voir l'URL] - Postgresql (Knex) - Running in Docker If you're familiar with the technology and read this description start by "4+4=8" And send us your github handler + Linkedin profile (not required)

    €1925 (Avg Bid)
    €1925 Offre moyenne
    27 offres
    Help with (sub)query S'est terminé left

    Hi, I want to search into my walks database depending on the length. html is working, subquery is working but can't get the data from the right table. The subquery is if($f_len) $subquery_conditions .= "AND `length` BETWEEN '".($f_len - $f_len_range)."' AND '".($f_len + $f_len_range )."' "; } And that has to come from t...

    PHP
    €22 (Avg Bid)
    €22 Offre moyenne
    9 offres

    select fund_id, '{fund[fund_name]}' as fund_name, Coalesce((SELECT 100*round(SUM(cast(sdm_aao5_1.base_market_value as numeric(10,2)))/ NULLIF((select sum(cast(a3.base_market_value as numeric(10,2))) from sdm_aao5_1 as a3 where a3.overall_report_end_date <> '2019-09-30') ,10),10) from sdm_aao5_1 group by sdm_aao5_1.fund_id),0) AS austrian_bond_percentage_py, Coalesce((SEL...

    €24 (Avg Bid)
    €24 Offre moyenne
    20 offres
    CSGO Case Opening Website Update S&#039;est terminé left

    We are currently running a CSGO case opening website. We are looking for a Full-Stack Javascript Developer who can join our team to develop scalable and maintainable new game modes including Case Battle, Upgrade, etc. Our tech stack includes: - Node.js - Knex - Docker - Kubernetes - Redis - Postgres - Vue 2 - SCSS and more ! Our stack is running on AWS and using: EC2, RDS (Aurora/postgres), Ela...

    €1875 (Avg Bid)
    €1875 Offre moyenne
    8 offres
    NodeJs, Express JS, Knex S&#039;est terminé left

    Hi, Looking for backend developer who has experience on NodeJS, AngularJS, MySQL (Migration seeding and scripting).

    €103 (Avg Bid)
    €103 Offre moyenne
    6 offres

    Hello, The project I have need a knex migration which I wrote but when I run the migration I got an error as described in this question [se connecter pour voir l'URL] I never used knex before so I don't know the issue I explained in the question. I hope I can receive support via screen sharing to solve the migration issue. The stack of the project has also Node, postgresql, Graphql ...

    €18 (Avg Bid)
    €18 Offre moyenne
    1 offres
    Macro Creation Project CSV file S&#039;est terminé left

    we have to create Database query in given format from CSV data file. It should have necessary macro to create format. CSV file have following information: 1. Table Name 2. Column name 3. Column Type 4. Column subtype whether it will include in the subquery Note: Number of column can vary and CSV file can have multiple rows of the data Please find the template for reference

    €23 (Avg Bid)
    €23 Offre moyenne
    22 offres
    Node API server S&#039;est terminé left

    I need a node/express api server that uses passport to authenticate people. I would like local and facebook strategies setup. I also want CRUD api endpoints for users. The following are the items I need integrated into the project. All elements must be included in the project. Express Passportjs Knex Postgres Swagger

    €139 (Avg Bid)
    €139 Offre moyenne
    14 offres

    i need to build a backend nodejs API for a grocery delivery stack required . nodejs express knex(database ORM) - optional postgresql - Endpoints needed /admin /customers /items /orders /delivery

    €143 (Avg Bid)
    €143 Offre moyenne
    21 offres
    Laravel Subquery Filter S&#039;est terminé left

    Please refer to the collection object data as attached. My code is as below: $products = $searchResultQuery->with(['child','combovariant','thumbnail'])->where('view',1)->get(); now the condition I intend to achieve is when list_price is less than cost_price then $products should contain only records that meet the condition. Otherwise when list_pri...

    €22 (Avg Bid)
    €22 Offre moyenne
    10 offres

    need to change some ui part in my running existing application only two component only.

    €7 / hr (Avg Bid)
    €7 / hr Offre moyenne
    15 offres

    I have a teeny tiny crud app running on express/node, that stores data in a postgres database. there are a handful of routes, and 2 tables (its just a proof of concept). The app is not much more than a simple todo type app. it works well as is, but i want to dockerize it so it can be run anywhere. it uses node to serve it with express, postgres to store data and knex as a query builder. I have mig...

    €120 (Avg Bid)
    €120 Offre moyenne
    7 offres
    Graphql/Node JS Backend Developer S&#039;est terminé left

    We are looking to bring in an additional developer to help with backend development across multiple client projects. We are looking for an experienced developer who can handle complex tasks without a ton of help. You will be working on existing codebases, and it will be important for you to be comfortable navigating legacy code bases. You will be invited to our company Slack so that you can inter...

    €18 / hr (Avg Bid)
    €18 / hr Offre moyenne
    27 offres

    Using starter code, write a few statements and make sure it passes all the unit tests provided: List all customers in database (listAllCustomers) List all orders for a customer (listCustomerOrders) List all lineitems for an order (listLineItemsForOrder) Computer order total (computeOrderTotal) Add a customer (addCustomer) Delete a customer (deleteCustomer) (Make sure to also delete Orde...

    €39 (Avg Bid)
    €39 Offre moyenne
    7 offres

    Currently using knex connection on mariadb in Docker and receiving the following error. ER_DBACCESS_DENIED_ERROR: Access denied for user ''@'localhost' to database ''

    €38 (Avg Bid)
    €38 Offre moyenne
    4 offres

    4 Questions with corresponding queries Each SQL query needs to include one or more explicit JOINs. The JOIN or JOINs should be necessary to the query. Each SQL query needs to include one or more aggregations. This could be a COUNT, AVG, SUM, or other aggregation. 2 of the 4 SQL queries need to include either a subquery OR a CTE. 1 of the 4 queries should use a Window Function. The SQL queries ar...

    €95 (Avg Bid)
    €95 Offre moyenne
    12 offres

    I need someone who has experience teaching, has experience with Node, with Knex and with POSTGRESQL. Who can teach me how to use them as I have experience with Node, Knex with sqlite3 just not postgresql and I find the knex documentation to be extremely frustrating. You need to be able to speak proper english. I need someone to do a video or a couple videos that teach how to set up a postgresql d...

    €140 (Avg Bid)
    €140 Offre moyenne
    4 offres

    I need someone who has experience teaching, has experience with Node, with Knex and with POSTGRESQL. Who can teach me how to use them as I have experience with Node, Knex with sqlite3 just not postgresql and I find the knex documentation to be extremely frustrating. You need to be able to speak proper english.

    €11 / hr (Avg Bid)
    €11 / hr Offre moyenne
    10 offres
    Trophy icon MySQL query optimization S&#039;est terminé left

    I need to optimize a MySQL query. I've been reading the docs about optimization in MySQL docs but It's been hard for me to comprehend it. I have two tables: vehicles CREATE TABLE `vehicles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `metadata` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, ...

    €8 (Avg Bid)
    Garanti
    €8
    7 propositions
    Database Management Systems S&#039;est terminé left

    Using SQL to (i) create and manipulate database tables, and (ii) extract information from a database. 1. List the complete Tasks table. [11 points] Answer: 2. List the number and name of all clients that are represented by consultant 22 or that have credit limits of $10,000. [11 points] Answer: 3. For each work order, list the order number, order date, number of the client that placed the order...

    €28 (Avg Bid)
    €28 Offre moyenne
    13 offres

    Reports module changes as per our reqirement

    €158 (Avg Bid)
    €158 Offre moyenne
    3 offres

    Generate crud operations for 2 [se connecter pour voir l'URL] integrate front end angular application with backend using express and postgresql. Modules: Employee Agent Allocation of Job Reports

    €34 (Avg Bid)
    €34 Offre moyenne
    5 offres

    I would like someone to write me a mysql subquery which extracts two sets of information from a mySQL database and then presents them side by side. The output should be a mySQL View. Attached you will find [se connecter pour voir l'URL] and result.csv. These represent a sample of the database file and the desired output. Things to note in the [se connecter pour voir l'URL] file F...

    €145 (Avg Bid)
    €145 Offre moyenne
    14 offres
    Need help with the sql query S&#039;est terminé left

    Need help with the sql query for the following: Need to add a subquery to the Supplier table script - select supplier ID (d1_fornece) and invoice date (d1_emissao) from table SD1330, join to SF1330 (as in the Invoice query) and then from that table to SE4330 where payment terms are in the field E4_DESCRI. Select only the most recent record, by invoice date, for each supplier. Join this back to SA2...

    €18 (Avg Bid)
    €18 Offre moyenne
    30 offres
    Node.js+SQL+Linux S&#039;est terminé left

    THE VACANCY IS FOR BELARUSIAN DEVELOPERS ONLY. Из «на каждый день» node.js и, соответственно, JavaScript, как язык hapi — как серверный фреймворк mySQL — как СУБД. Каких-то обёрток вроде sequelize или knex, там нет. Желательно знание linux, но не критично. По стеку и по структуре — очень простой проект, он делался из расчёта на то, что его будут поддерживать непрофил...

    €17 / hr (Avg Bid)
    €17 / hr Offre moyenne
    12 offres
    MS-Access expert for reporting S&#039;est terminé left

    We have 2 tables in database. Address Table - Keeps address details (Key address id) Member Table - Keeps detail of each member, their corresponding address_id and if a member is a head of the family or not. The circulars are posted per family(address) with Head of the family's name on the posting label. Labels are printed via MS-Access report. I need a query where we can print a page per a...

    €26 (Avg Bid)
    €26 Offre moyenne
    25 offres
    PostgreSQL training S&#039;est terminé left

    I have a two day advanced PostgreSQL training in Bangalore on 26th and 27th of November and will pay INR 50,000/- total for the program. Anyone who had good experience in SQL and has trained on it can reach me at 9731657840. The Topics to be covered are below. It is a full day training on two days and dates are fixed. • SQL UNION • SQL UNION ALL • SQL INTERSECT • SQL MI...

    €684 (Avg Bid)
    €684 Offre moyenne
    5 offres
    Simple PostgreSQL 9.6 subquery S&#039;est terminé left

    I have an int type column on one table and a json type column on a different table. I need a query that selects all rows from the int type column, separates them by a comma and UPDATES the json type column on a specific row with an array [] containing those comma-separated values.

    €24 (Avg Bid)
    €24 Offre moyenne
    11 offres
    Lab03-Database S&#039;est terminé left

    1.A. Find the name and phone number of each vendor who has a cooperating vendor. Hint: the vendors for whom the field Cooperating_Vendor_id is not empty B. Now find additionally the name and phone number of the cooperating vendor. Present these two columns as: ‘cooperating vendor’ and ‘cooperating vendor phone’. [se connecter pour voir l'URL] the above query to...

    €27 (Avg Bid)
    €27 Offre moyenne
    2 offres
    A basic Tsql query S&#039;est terminé left

    I need a basic tsql query for a the attached spreadsheet to produce the desired output. I believe I need a subquery to output file where; Distinct records where the status <> 'Active' Where there are duplicate records with multiple Status I need to output only one record where there are no Status = 'Active' The purpose of the report is to determine which stores do not cu...

    SQL
    €14 (Avg Bid)
    €14 Offre moyenne
    10 offres
    Fix error in Opencart e-commerce S&#039;est terminé left

    if i add product on opencart, it will take other product name "Peruskone 1" Maybe it is because product takes wrong ID from MySql???? After i edit that product it gives error: "Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/datastoppi/system/library/db/[se connecter pour voir l'URL] on line 19Notice: Error: Subquery returns more than 1 r...

    €23 (Avg Bid)
    €23 Offre moyenne
    8 offres
    My SQL Query assistance S&#039;est terminé left

    I have provided a script to create the database and need a professional to get the provided SELECT query to work correctly. I have a subquery that needs to serve up a single row result based on the results on single-row or multi-row results from another subquery.

    €14 (Avg Bid)
    €14 Offre moyenne
    39 offres

    Current project in development and I need someone sho knows Angular5, Material2 and AWS to help finish the last pieces and cleanup the UI. The project is a customized shopping cart project with the following pieces left to do. -Add stripe to the order process -Add shipping method to the order process -Add Can Deactivate guard -Add Federated Tokens for upload to AWS S3. General clean up o...

    €284 (Avg Bid)
    €284 Offre moyenne
    4 offres
    Assistent for node.js project S&#039;est terminé left

    It is difficult to describe my needs, but basically I need assistant in writing node.js application. It is backend service for mobile app. I never worked with node.js before and I have many questions. I need some very experienced developer to be able a) Main task: review what I write (REST API with MySQL database). Probably, suggestions on projec structure and authentification (not implem...

    €26 / hr (Avg Bid)
    €26 / hr Offre moyenne
    34 offres
    Build Mysql Subquery S&#039;est terminé left

    Music database: Query "Recently played" table and return first row Query "All Songs" table and return 10 random songs from "recently played" query. Have tried this code so far: SELECT @lastsong :=Artist FROM [se connecter pour voir l'URL] WHERE artist LIKE '%' ORDER BY date_played DESC LIMIT 1 SELECT * FROM [se connecter pour voir l'URL]...

    €15 (Avg Bid)
    €15 Offre moyenne
    24 offres

    MySQL Subquery expert need to combine two queries in a query.

    €12 (Avg Bid)
    €12 Offre moyenne
    30 offres

    I need a SQL statement written for an ORACLE db - I use SQL developer. Hi all, I need SQL to compare the below 2 sub queries and then only show values that are different in the 'latest' (subquery2) subquery. Both subqueries use the same table to SELECT FROM: **Subquery 1:** select tra_rac_accno, tra_cr from transactions join admin_periods on trunc(sysdate-7) between ape_s...

    SQL
    €17 (Avg Bid)
    €17 Offre moyenne
    2 offres
    Fix a single MySQL query S&#039;est terminé left

    I am currently selecting a number of rows, joining another table but can have duplicate entries. I want to remove the duplicates (which I have done), but I want to keep the one with the latest time (bidTime) and using MAX(bidTime) doesn't work. Using ORDER BY doesn't work because it needs to order by from the JOIN table. Maybe I need a subquery, but I'm not familiar with those. I...

    €20 (Avg Bid)
    €20 Offre moyenne
    42 offres

    We a startup and need someone to finish our MVP and make it functional and so we can begin getting users. Developer must be able to do full-time work, united states based, and HAS to sign an NDA and keep information and coding created to us or face a lawsuit from our legal council. MUST BE WILLING TO START TODAY. Job Details: - Bootstrap Responsive Mobile - Data Binding and Depende...

    €15 / hr (Avg Bid)
    €15 / hr Offre moyenne
    29 offres
    Full Stack Developer for Startup S&#039;est terminé left

    We a startup and need someone to finish our MVP and make it functional and so we can begin getting users. Developer must be able to do full-time work, united states based, and HAS to sign an NDA and keep information and coding created to us or face a lawsuit from our legal council. MUST BE WILLING TO START TODAY. Job Details: - Bootstrap Responsive Mobile - Data Binding and Depende...

    €27 / hr (Avg Bid)
    €27 / hr Offre moyenne
    34 offres
    write a small subquery S&#039;est terminé left

    Write a small subquery to meet a certain output.

    SQL
    €49 (Avg Bid)
    €49 Offre moyenne
    10 offres
    MSSQL Query Fixed S&#039;est terminé left

    Hi, I have a query on MSSQL server which I'm trying to build but I'm getting error - Msg 130, Level 15, State 1, Line 8 Cannot perform an aggregate function on an expression containing an aggregate or a subquery. Attached is the query which I have. The query is using When & Case for variables in the calculation. Please note should you take on the project you will agree to...

    €25 (Avg Bid)
    €25 Offre moyenne
    6 offres
    Create a subquery -- 3 S&#039;est terminé left

    Create a subquery that will bring dates before a specific date(May 2017)

    SQL
    €14 (Avg Bid)
    €14 Offre moyenne
    33 offres
    Create a subquery -- 2 S&#039;est terminé left

    Create a subquery that will bring dates before a specific date(May 2017)

    SQL
    €17 (Avg Bid)
    €17 Offre moyenne
    29 offres
    Create a subquery S&#039;est terminé left

    Create a subquery that will bring dates before a specific date(May 2017)

    SQL
    €18 (Avg Bid)
    €18 Offre moyenne
    7 offres
    Small Movies Database (no GUI) S&#039;est terminé left

    Project description You are required to design and implement a small Movies database application Design and Implementation Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database. In the E-R diagram, 1, there must be at least 4 entities; 2, there must be at least 2 one-to-many/one-to-one relationships; 3, ther...

    €89 (Avg Bid)
    Urgent
    €89 Offre moyenne
    3 offres
    Server deployment S&#039;est terminé left

    Hi guys, I'm new to backend and learning node.js. I'm trying to deploy a node app with knex-mySQL, express and redis on a Ubuntu server using pm2. And I've been stuck for a week now trying to configure the server to run my app. Can anyone guild me through the process and help me deploy the app? PS: I will pay you for your time.

    €104 (Avg Bid)
    €104 Offre moyenne
    17 offres
    SQL Assignment - Repost S&#039;est terminé left

    1‐ In how many distinct locations are the departments located?  2‐ How many employees are there in each phone area code? Sort by area  code.  3‐ How many locations do NOT have postal codes starting with a number?  4‐ Find&nbs...

    €8 (Avg Bid)
    €8 Offre moyenne
    1 offres

    > I am learning Javascript/React for the first time. > My task is to build a simple application/personal project. This project is a simple project management tool. I need an expert Javascript developer etc to work with me for 4 hours on Sunday 9, (tommorrow) starting at 9am (Auckland time) to help build this project. > The expert programmer will provide good instructions [The administra...

    €186 (Avg Bid)
    €186 Offre moyenne
    1 offres
    SQL Assignment S&#039;est terminé left

    1‐ In how many distinct locations are the departments located?  2‐ How many employees are there in each phone area code? Sort by area  code.  3‐ How many locations do NOT have postal codes starting with a number?  4‐ Find...

    €23 (Avg Bid)
    €23 Offre moyenne
    8 offres