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

Why MySQL is used?

0 Answers  

How many ways to get the current time?

0 Answers  

Print 3 highest salary

9 Answers  

Is mysql is a programming language?

0 Answers  

How much does mysql enterprise cost?

0 Answers  

What is a trigger in mysql?

0 Answers  

What is the insert?

0 Answers  

How to calculate expressions with sql statements?

0 Answers  

Is mysqli faster than mysql?

0 Answers  

How to find the unique values if the value in the column is repeated?

0 Answers  

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 Answers  

How do I start mysql database?

0 Answers  

For more MySQL Interview Questions Click Here
Categories