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
- 3768 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
Can we create table in stored procedure?
Can you tell what are various ways to create an index?
Which mysql function is used to concatenate string?
What is a left join mysql?
What are different types of queries?
What is the latest version of mysql?
What is clob datatype?
What is 'mysqldump'?
How do I change the max connection in mysql?
What is mysql cursor?
Who developed mysql?
Why do gaps in sequences occur?
Can you tell which of the following where clauses is faster?
What is delimiter in mysql stored procedure?
How to dump a table from a database.
