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

How do I show users in mysql?

0 Answers  

What is delimiter $$?

0 Answers  

Will mysql remain free?

0 Answers  

How does limit work in mysql?

0 Answers  

How to copy data from one server to another using php?

0 Answers  

Can you tell the difference between ereg_replace() and eregi_replace()?

0 Answers  

What is row level locking in mysql?

0 Answers  

What are the disadvantages of stored procedures?

0 Answers  

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,

change column name and make a unique column so we get no dupes.

0 Answers  

How do I edit a table in mysql?

0 Answers  

What is sharding in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories