Search & Filtering
Databases | SQL | Oracle | MS Access
How can I create objects (Tables, views ..) using Oracle DBMS.
Databases | SQL | Oracle | MS Access
I am making balance sheet in crystal report using sql database
i have these columns
Account Name : Dr : Cr : Balance
Col Balance is Formula field in crystal report
i want in every row to last Row Balance + Dr - Cr = (Current Row Balance)
How can i do this in Crystal report or in query in sql? plz help
i have these columns
Account Name : Dr : Cr : Balance
Col Balance is Formula field in crystal report
i want in every row to last Row Balance + Dr - Cr = (Current Row Balance)
How can i do this in Crystal report or in query in sql? plz help
Databases | SQL | Oracle | MS Access
what join brifly describe form data base of SQL server
Databases | SQL | Oracle | MS Access
How do you begin creating a spatial database in SQL
Databases | SQL | Oracle | MS Access
select @StrName = UserId from productuser where ProductID in
((select ProductID from productassets where AssetID in(select AssetId from course where Title='Programming'))
INTERSECT
select ProductID from organizationproduct where OrganizationID in (select OrganizationID from organization where OrganizationName='Infosys'))
how to use for or while loop in sql query to get first ten values
((select ProductID from productassets where AssetID in(select AssetId from course where Title='Programming'))
INTERSECT
select ProductID from organizationproduct where OrganizationID in (select OrganizationID from organization where OrganizationName='Infosys'))
how to use for or while loop in sql query to get first ten values
Databases | SQL | Oracle | MS Access
I am trying to update a field in MySql:
the basic premis is:
FIeld X = Field Y + 30 (both X and Y are numeric)
Both fields are in the same table.
I tried update <tablename> set X = (Y+30) where condition = Z
I then tried update <tablename> set X = sum (Y+30) where condition = Z
both failed. Can you help?
the basic premis is:
FIeld X = Field Y + 30 (both X and Y are numeric)
Both fields are in the same table.
I tried update <tablename> set X = (Y+30) where condition = Z
I then tried update <tablename> set X = sum (Y+30) where condition = Z
both failed. Can you help?
Databases | SQL | Oracle | MS Access
how to fix SQLSTATE 42000 - consistency error while restoring the SQL Database
Databases | SQL | Oracle | MS Access
I have submitted my assignment but have not recieved any information from you. This has been in "checking" status for over one week. Please see attached
Databases | SQL | Oracle | MS Access
Design an Entity-Relationship Diagram (ERD) for the following database required
by ‘Chan Furniture’ company with the following details:
1. The company sells a number of different furniture products.
The identifier for a product is Product_ID Other attributes for product include Product_Description, Product_Finish, and Unit_Price.
2. Orders must be submitted in order to request for the products
The identifier for an order is Order_ID, and another attribute is Order_Date. An order must consist of at least one product. Any product sold by Chan may not be requested on any order, or may be requested on one or more orders. An attribute associated with each order and product is Quantity, which is the number of units requested.
3. A customer may submit any number of orders, but need not submit any orders.
Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Address.
by ‘Chan Furniture’ company with the following details:
1. The company sells a number of different furniture products.
The identifier for a product is Product_ID Other attributes for product include Product_Description, Product_Finish, and Unit_Price.
2. Orders must be submitted in order to request for the products
The identifier for an order is Order_ID, and another attribute is Order_Date. An order must consist of at least one product. Any product sold by Chan may not be requested on any order, or may be requested on one or more orders. An attribute associated with each order and product is Quantity, which is the number of units requested.
3. A customer may submit any number of orders, but need not submit any orders.
Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Address.
Databases | SQL | Oracle | MS Access
display the department information from dept table ?
