Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 mysqli_free_result?

0 Answers  

Explain the difference between delete and truncate.

0 Answers  

What is orm in mysql?

0 Answers  

How can I compare two mysql databases?

0 Answers  

What is the difference between unix timestamps and mysql timestamps?

0 Answers  

How to declare variable in mysql trigger?

0 Answers  

What are mysql data types?

0 Answers  

What are the types of index?

0 Answers  

What are the applications required to support mysql?

0 Answers  

How do I disable mysql?

0 Answers  

What is a storage engine? What are the differences between innodb and myisam engines?

0 Answers  

How to insert dynamic values in mysql using php?

0 Answers  

For more MySQL Interview Questions Click Here
Categories