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 are the differences between char and varchar data types?

0 Answers  

Explain % and _ inside like statement?

0 Answers  

What is mysql common?

0 Answers  

Where is the mysql database stored?

0 Answers  

What is the usage of "i-am-a-dummy" flag in mysql?

0 Answers  

What is mysql in dbms?

0 Answers  

Define REGEXP?

0 Answers  

Can we use mysql and mysqli together?

0 Answers  

What are the mysql database files stored in system ?

0 Answers  

How to save images in MySQL?

2 Answers  

What is mysql57?

0 Answers  

how we can use more then one primary key in Single Table

9 Answers   Systematix,

For more MySQL Interview Questions Click Here
Categories