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

How would concatenate strings in mysql?

0 Answers  

How do you restart mysql?

0 Answers  

What is mysql common?

0 Answers  

How to Change a users password from unix shell.

0 Answers  

What are the types of index?

0 Answers  

How to create a table index in mysql?

0 Answers  

Where the database is stored in mysql?

0 Answers  

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

0 Answers  

What is the latest version of php and mysql?

0 Answers  

Can mongodb replace mysql?

0 Answers  

What is longblob in mysql?

0 Answers  

How do I get a list of table names in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories