Skip to content
September 13, 2025

Create a table DRUGDB with the fields given in below table and assuming data type of your own.

SQL

SQL Queries

(a) Create table DRUGDB (schema based on the displayed sample):

(b) SQL commands for the specific requests

(i) To increase the price of “Paracetamol” by 35

(ii) To display the DrugID, RxID and PharmacyName of all records in descending order of their price

(iii) Display all the details of the drugs where name starts with ‘C’ and has ‘sh’ somewhere in the name

(iv) Display the drug name in lower case along with the price rounded off to nearest integer

(v) Delete the field (column) loc from drugdb table

Blog Insights