Create medicine table and write queries for following

MYSQL

SOLUTION

1. Display the unique manufacturer from medicine

Sol :- 

2. Display manufacturer and total price for each manufacturer

Sol :- 

3. Display manufacturer and price in the ascending order of price

Sol :- 

4.Display first 4 characters of medicinename which medicine id contains 5 as last digit 

Sol :- 

5. Display all medicine names in Capital letter

Sol :- 

Leave a Reply

Your email address will not be published. Required fields are marked *

sign up!

We’ll send you the hottest deals straight to your inbox so you’re always in on the best-kept software secrets.

© Copyright CODEMANIAC STUDIO ™

Twitter Facebook-square Linkedin Youtube