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

In mysql, what is joins? Explain

0 Answers  

Is mariadb faster than mysql?

0 Answers  

can you elaborate on blob and text in mysql? : Mysql dba

0 Answers  

Explain what is mysql?

0 Answers  

What are the types of index?

0 Answers  

What is a query in mysql?

0 Answers  

How do I remove a user from mysql?

0 Answers  

Describe mysql transaction properties.

0 Answers  

What are the advantages and disadvantages of using mysql?

0 Answers  

What is mysqlcheck do?

0 Answers  

How do I install mysql?

0 Answers  

What is logs in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories