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 mysql optimization in brief?

1 Answers  

What are date and time data types in mysql?

1 Answers  

What is user in mysql?

1 Answers  

What is mysql used for?

1 Answers  

How to use regular expression in pattern match conditions?

1 Answers  

maximum size of a database in mysql?

2 Answers  

What is unsigned int in mysql?

1 Answers  

What is cast in mysql?

1 Answers  

How do I change the max connections in mysql?

1 Answers  

What is int mysql?

1 Answers  

Which statement is used in a select query for partial matching?

0 Answers  

In which language it is written?

1 Answers  

For more MySQL Interview Questions Click Here
Categories