SELECT *
FROM (`youtube_videos`)
WHERE `display_status` = 1
ORDER BY `video_id` desc
LIMIT 40SELECT *
FROM (`youtube_videos`)
WHERE `display_status` = 1
ORDER BY `video_id` desc
LIMIT 40 Data Manipulation Through SQL 12th Standard
Computer Science Which of the following function retrieves the average of a selected column of rows in a table? Add() SUM() AVG( ) AVERAGE() The function that returns the largest value of the selected column is MAX() LARGE() HIGH() MAXIMUM() Which of the following is called the master table? sqlite_master sql_master main_master master_main The most commonly used statement in SQL is cursor select execute commit Which of the following clause avoide the duplicate? Distinct Remove Where GroupBy Which method is used to connect a database? Give an example. Write the command to populate record in a table. Give an example. Which method is used to fetch all rows from the database table? What is SQLite?What is it advantage? Mention the difference between fetchone() and fetchmany() What is the use of Where Clause.Give a python statement Using the where clause. hat is the use of HAVING clause. Give an example python script Consider the following table Supplier and item .Write a python script for (i) to (ii) i) Display Name, City and Itemname of suppliers who do not reside in Delhi.12th Computer Science Chapter 15 Data Manipulation Through SQL Book Back Questions
Question Bank Software Sep-07 , 2019
Data Manipulation Through SQL Book Back Questions
Reg.No. :
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
ii) Increment the SuppQty of Akila by 40
*****************************************
Reviews & Comments about 12th Computer Science Chapter 15 Data Manipulation Through SQL Book Back Questions
Write your Comment