1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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.

Question Posted / pranab


For the database from the previous question, please give an SQL query which returns the invoice nu..

Answer / 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

More MySQL Interview Questions

Where’s database data actually stored?

0 Answers  

How to use rank function in mysql?

0 Answers  

What do you mean by % and _ in the LIKE statement?

0 Answers  

What is the limit of mysql database?

0 Answers  

What is join in mysql? What are the different types of join?

0 Answers  




Is mysql a odbc?

0 Answers  

What do ddl, dml, and dcl stand for?

0 Answers  

Why use stored procedures in mysql?

0 Answers  

Explain the different types of constraints?

0 Answers  

What is a procedure example?

0 Answers  

What is the difference between having and where clause in mysql? Explain

0 Answers  

How do I check mysql version?

0 Answers  

For more MySQL Interview Questions Click Here
Categories