Skip to content

Consider two left join with same table SQL

I have this query I need to consider procedimentos when faturamento_lancamentos_bpa_adicionais.procedimento_id and faturamento_lancamentos_bpa.procedimento_id Answer You need to alias the “doubled” tables, as every entity needs a unique name The use of meaningful aliases will keep also the query b…

Exclude Records Based on Criteria

I need to exclude the record: If a customer bought “Shoe” and “Hat” on the same day, exclude the record with “Hat”. If a customer bought “Shoe” and “Cloth” on the same day, exclude the record with “Cloth”. Here is the sample data: Here ar…

INSERT INTO query WITH RECURSIVE query

I have created a WITH RECURSIVE function and would like to use it with an INSERT INTO function so that the results insert into the path column. category_id category_name parent_id path 1 Root 0 2 Fishing 1 3 Sea 2 4 Lures 3 7 Coarse 2 8 Lures 7 9 Fly 2 I have tried the following code but the

How to apply this query to all the employees

I have a query to compute the 3rd highest salary for an employee as shown below. How can I apply this query to give the 3rd highest salary for each employee which can be fetched by the query Note: without using special functions like dense_rank() Answer You are looking for each employee’s third highest …