SQL – Page 1200 – SQL Questions Answer

MySQL sum() from more than 1 table

Ok, so every sum() returns the desired value, I already checked it but I’m having problems when trying to sum everything together and then get the total value. Basically I have to do this: initial Fee(which is a set value defined on the”customer” table) + sum of activity1 cost + sum of activity2 cost == value But I don’t know

Delete from child table with two parents without cascade delete in sql server

cascade parent-child sql sql-delete sql-server

I need your guidance. I create a script to delete from 3 tables separately. meaning when I created the script is to delete from table3 (child) then delete from 2 (child), then delete from table1(parent) I am having problem with Table3 since table2 has foreign key both for table2 and table1 so I cannot delete it before I delete table2

Counting rows in different tables and grouping by a certain criteria

counting oracle sql

I have 3 tables: Projects, Components, Suppliers. Each one has an id column, city column and some other columns. What I am trying to do is count how many projects, components and suppliers there are for each city. What I have tried is: After running this query, I am getting incorrect values, almost all of them are the same, like

SQL query fetching data from multiple tables and displaying in html table

php sql

I am working on a system that fetches data from three tables. My query takes input from a form stored in variables named $departure and $destination. However the query is not working when i use these variables but if i enter result in sql query then it fetches data from sql. I echoed $departure and $destination to check if they

Need to parse a date range location in a field to two SQLStatements

netsuite parsing sql

Have a custom field that contains a date range in the following format: What I need to do is separate this one line into two different fields, the first selection/range and the second range, so if you take the screenshot I need it to be separated to 3/16/20 for one field and 3/22/20 for the other field. Currently I have

MySQL sum() from more than 1 table

Delete from child table with two parents without cascade delete in sql server

Counting rows in different tables and grouping by a certain criteria

SQL query fetching data from multiple tables and displaying in html table

Need to parse a date range location in a field to two SQLStatements

How to get x top results for each year SQLite

IsNullOrEmpty with an empty value still go into the loop

Converting SQL query result to XML [closed]

String or binary data would be truncated when using it in a stored procedure

How to retrieve SQL Error message with Hibernate