Questions tagged [database-management]
109 questions
-1
votes
1 answer
Database administration tool vs database management system?
i am using Microsoft SQL Server Management Studio. I though it was a database management system, until today I realized that the database management system is actually Microsoft SQL Server.
So i would like to know what relation and differences are…
Tim
- 1
- 122
- 314
- 481
-2
votes
1 answer
How to find frequency of a value in two different columns in sql?
I have a table which shows arrival airport and departure airport of flights.
I need to find arrivals and departures of every airport
First one is the given table and second is the required table
I have tried the following
SELECT T.departure,…
starlord
- 3
- 2
-2
votes
2 answers
What is the best free (or under 200 dollar) database manager software?
I am currently using Toad, but am not very satisied.
Spencer
- 17,912
- 32
- 79
- 116
-5
votes
1 answer
How to join each order with its price?
I have two tables named PRICES and ORDERS.
PRICES
Product_ID
price
1
50
2
100
ORDERS
CUSTOMER_ID
Product_ID
QUANTITY
123
1
3
456
2
5
789
2
2
327
1
7
I want to join these two tables to get below expected…
nezamas
- 1
- 2