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

Can foreign key have duplicate values?

0 Answers  

How do I transfer data from one database to another in mysql?

0 Answers  

How to create triggers in MySQL?

1 Answers  

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

0 Answers   ACC,

about join

2 Answers  

How do you restart mysql?

0 Answers  

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

How to calculate the difference between two dates?

0 Answers  

Consider you have the following three tables which have to be linked together.

0 Answers  

Is mysql easy to learn?

0 Answers  

How to use like conditions?

0 Answers  

Why do we use group by and order by function in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories