Sql

04/29/19

IF' in 'SELECT' statement - choose output value based on column values?
SELECT id, amount FROM report I need `amount` to be `amount` if `report.type='P'` and `-amount` if `report.type='N'`. How do I add this to the above query?
Follows • 1
Expert Answers •1
Sql

04/28/19

IN vs OR in the SQL WHERE Clause?
When dealing with big databases, which performs better, `IN` or `OR` in the SQL `Where`-clause? Is there any difference about the way they are executed?
Follows • 1
Expert Answers •2
Sql

04/22/19

What is the difference between JOIN and UNION?
What is the difference between `JOIN` and `UNION`? Can I have an example?
Follows • 1
Expert Answers •2

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.