Advertisements
Advertisements
Question
Give a python statement Using the where clause.
Solution
import sqlite3
connection = sqlite3.
connect(“Academy, db”)
cursor = connection. cursor()
cursor, execute (“SELECT DISTINCT (Grade) FROM student where gender=’M'”)
result = cursor. fetchall()
print(*result, sep=”\n”)OUTPUT:
(‘B’,)
(‘A’,)
(‘C’,)
(‘D’,)
APPEARS IN
RELATED QUESTIONS
Which of the following executes the SQL command to perform some action?
The most commonly used statement in SQL is ______
Which of the following clause avoid the duplicate?
Which method is used to fetch all rows from the database table?
Mention the difference between fetchone() and fetchmany().
What is the use of the Where Clause?
Consider the following table Supplier and item. Write a python script for the following Question?
| SUPPLIER | ||||
| Suppno | Name | City | Icode | SuppQty |
| S001 | Prasad | Delhi | 1008 | 100 |
| S002 | Anu | Bangalore | 1010 | 200 |
| S003 | Shahid | Bangalore | 1008 | 175 |
| S004 | Akila | Hydrabad | 1005 | 195 |
| S005 | Girish | Hydrabad | 1003 | 25 |
| S006 | Shylaja | Chennai | 1008 | 180 |
| S007 | Lavanya | Mumbai | 1005 | 325 |
Increment the SuppQty of Akila by 40
Write a Python script to create a table called ITEM with the following specifications.
Add one record to the table.
Name of the database:- ABC
Name of the table:- Item
Column name and specification:-
| Icode | :- | integer and act as primary key |
| Item Name | :- | The character with a length of 25 |
| Rate | :- | Integer |
| Record to be added | :- | 1008, Monitor, 15000 |
Write the Python script to display all the records of the following table using fetchmany().
| Icode | ItemName | Rate |
| 1003 | Scanner | 10500 |
| 1004 | Speaker | 3000 |
| 1005 | Printer | 8000 |
| 1008 | Monitor | 15000 |
| 1010 | Mouse | 700 |
The hat is the use of the HAVING clause. Give an example python script.
