Interested to Buy Any Domain ? << Click Here >> for more details...
For the database from the previous question, please give an
SQL query which returns the invoice number of all invoices
which contain the article with the number ?1234?. The query
should be able to run under a MySQL 4.0 database.
- 1 Answers
- 3669 Views
- I also Faced
- E-Mail Answers
Answer Posted / frank
SELECT invoiceNumber FROM invoices i INNER JOIN articles a
ON i.articleId=a.articleId WHERE article LIKE '%1234%';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to add a new column to an existing table?
how to Return total number of rows.
What is username in mysql?
What is the data source name for mysql?
What is 'mysqlimport'?
What do ddl, dml, and dcl stand for?
What is the default port for MySQL Server?
What are the disadvantages of mysql?
How many TRIGGERS are allowed in MySql table?
How to use count function in mysql?
What is a string in mysql?
How do I copy an entire mysql database?
What are the column comparisons operators?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
Is mysql case-sensitive?
