Sign Up Login


  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

what is the Dynamic management views? where can you use?

1 Answers   ACC,

What is difference between schema and table?

0 Answers  

What are the differences between drop a table and truncate a table?

10 Answers  

Why we use mysqli instead of mysql?

0 Answers  

How do I add a column to a table in mysql?

0 Answers  

How to convert dates to character strings?

0 Answers  

Which command is used to view the content of the table in mysql?

0 Answers  

Is primary key auto increment?

0 Answers  

How do you use auto increment?

0 Answers  

What is “i_am_a_dump” flag in mysql?

0 Answers  

Can you rename a database in mysql?

0 Answers  

Where is mysql used?

0 Answers  

For more MySQL Interview Questions Click Here
Categories