SQL – Page 1120 – SQL Questions Answer

SQL: how to select distinct values with an offset

Given the following table: id value ——- ——- 0 1 1 6 2 7 3 9 4 2 5 20 6 21 7 3 I’m wondering if there’s a way to select distinct rows where there’s a difference between (integer) values of (for example) 3, giving a priority to id (low id value = more prioririty). Progr…

PostgreSQL: Inserting tuples in multiple tables using a view and a trigger

postgresql sql sql-view triggers

I am trying to build an order system that is able to insert a compound order that consists of multiple items and amounts. My database layout is as follows: I have an order table, containing an autoincrement id, item_id, amount and order_group_id columns. I also have an order_group table containing an autoincr…

How to sum multiple rows on trigger update?

sql sql-server

I wrote a trigger on update on table [CART] to count and insert value to other table [HEADERS] to column [SUM]. It works but only for 1 row where [CART].[NUMBER] = [HEADERS].[NUMBER]. Column [NUMBER] …

UNION 2 tables lots fields, few different, possible use SELECT *?

mysql sql union

I have 2 MYSQL tables, one with 794 fields, another with 796 fields, the common 794 fields the same. Yes genuine figures, importing data from old system to new one. If I do: SELECT foo FROM (SELECT …

I’m trying to know the country that pays the highest salary from

oracle-sqldeveloper oracle11g sql

select last_name, country_name, SUM(salary) from employees e JOIN departments d ON (e.department_id= d.department_id) JOIN locations L ON (d.location_id = L.location_id) JOIN Countries Cc ON (L….

Sybase ASE: how to print all table rows using cursor?

cursors sap-ase sql

The following code is supposed to print all rows contained in the temporary table #table_A: However, it results in the following error message: How can I print all rows contained in a (temporary) table? Here’s another way of putting my question: I’m trying to do something like that: Is there a way…

SQL: how to select distinct values with an offset

PostgreSQL: Inserting tuples in multiple tables using a view and a trigger

How to sum multiple rows on trigger update?

UNION 2 tables lots fields, few different, possible use SELECT *?

I’m trying to know the country that pays the highest salary from

Sybase ASE: how to print all table rows using cursor?

SQL create extra column which gets data from the table two columns

Indexing for dense_rank query in postgresql

Wrong data types when loading sql query with vba in excel