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

Is mysql open source?

0 Answers  

How can I insert images into a Mysql database?

0 Answers  

How many types of indexes are there in mysql?

0 Answers  

How do I change a procedure in mysql?

0 Answers  

How to use 'mysql' to run sql statements?

0 Answers  

Is mysqli deprecated?

0 Answers  

What is the limitation of mysql?

0 Answers  

How to return query output in html format?

0 Answers  

How we can get the current date in mysql?

0 Answers  

What is new mysqli?

0 Answers  

using primary can we relate two table, with out foreign key?

0 Answers  

How to use regular expression in pattern match conditions?

0 Answers  

For more MySQL Interview Questions Click Here
Categories