Interested to Buy Any Domain ? << Click Here >> for more details...
Table - Products has number of products as below
Productid ProductName
1
iPhone
2
iPad
3
BlackBerry
Table - SalesPersonProduct has the
below records
Salespersonid
productid
S1
1
S1
2
S1
3
S2
1
S3
2
Write a SQL query that returns the total number of sold products
- 0 Answers
- 2790 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Write a query to fetch duplicate records from a table using mysql?
How do I clear the command in mysql?
What are enums used for in mysql?
What is default password for mysql?
Is Mysql query is case sensitive?
How to returns the columns and column information pertaining to the designated table.
what is constraints? Also explain the different types of constraints?
How to show all tables with 'mysql'?
how we can use more then one primary key in Single Table
How to get last inserted id after insert data from a table in mysql?
which version of mysql can't support stored procedure??
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
