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

How to get a version of mysql?

0 Answers  

Why we use mysqli instead of mysql?

0 Answers  

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 Answers  

Is mongodb faster than mysql?

0 Answers  

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 Answers  




How do I import database through command line?

0 Answers  

How can increase the performance of MySQL select query?

3 Answers   RV Technologies, Span Systems,

What is schema in mysql?

0 Answers  

Explain the difference between procedure and function in mysql?

0 Answers  

How can I see mysql database?

0 Answers  

What is a query in mysql?

0 Answers  

How to display top 10 rows in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories