Advertisements
Advertisements
प्रश्न
The SELECT statement when combined with the ______ clause returns records without repetition.
विकल्प
DESCRIBEUNIQUEDISTINCTNULL
Advertisements
उत्तर
The SELECT statement when combined with the DISTINCT clause returns records without repetition.
Explanation:
The distinct values from a collection of values in a table field are returned by the DISTINCT clause.
APPEARS IN
संबंधित प्रश्न
Which function is used with the ORDER BY clause to custom sort order?
Consider the following SQL.
SELECT ______ FROM Employee WHERE Dept= 'Printing';
Which of the following should be used to find the mean of the salary?
Which of the following is not true for SQL?
Which of the following is not a constraint?
Which constraint ensures that a column cannot have NULL values where NULL means missing/unknown/not applicable value?
Which constraint ensures that all the values in a column are distinct/unique?
______ operator defines the range of values in which the common value must fall into to make condition true.
Write the output produced by the following SQL statement:
SELECT POW(2, 3);
Consider the following MOVIE table and write the SQL query based on it.
| MovieID | MovieName | Category | ReleaseDate | ProductionCost | BusinessCost |
| 001 | Hindi_Movie | Musical | 2018-04-23 | 124500 | 130000 |
| 002 | Tamil_Movie | Action | 2016-05-17 | 112000 | 118000 |
| 003 | English_Movie | Horror | 2017-08-06 | 245000 | 360000 |
| 004 | Bengali_Movie | Adventure | 2017-01-04 | 72000 | 100000 |
| 005 | Telugu_Movie | Action | - | 100000 | - |
| 006 | Punjabi_Movie | Comedy | - | 30500 | - |
- Display all the information from the Movie table.
- List business is done by the movies showing only MovieID, MovieName, and Total_Earning. Total_ Earning to be calculated as the sum of ProductionCost and BusinessCost.
- List the different categories of movies.
- Find the net profit of each movie showing its MovieID, MovieName, and NetProfit. Net Profit is to be calculated as the difference between Business Cost and Production Cost.
- List MovieID, MovieName, and Cost for all movies with ProductionCost greater than 10,000 and less than 1,00,000.
- List details of all movies which fall in the category of comedy or action.
- List details of all movies which have not been released yet.
Consider the following MOVIE table and write the SQL query based on it.
| MovieID | MovieName | Category | ReleaseDate | ProductionCost | BusinessCost |
| 001 | Hindi_Movie | Musical | 2018-04-23 | 124500 | 130000 |
| 002 | Tamil_Movie | Action | 2016-05-17 | 112000 | 118000 |
| 003 | English_Movie | Horror | 2017-08-06 | 245000 | 360000 |
| 004 | Bengali_Movie | Adventure | 2017-01-04 | 72000 | 100000 |
| 005 | Telugu_Movie | Action | - | 100000 | - |
| 006 | Punjabi_Movie | Comedy | - | 30500 | - |
List business is done by the movies showing only MovieID, MovieName, and Total_Earning. Total_ Earning to be calculated as the sum of ProductionCost and BusinessCost.
Consider the following MOVIE table and write the SQL query based on it.
| MovieID | MovieName | Category | ReleaseDate | ProductionCost | BusinessCost |
| 001 | Hindi_Movie | Musical | 2018-04-23 | 124500 | 130000 |
| 002 | Tamil_Movie | Action | 2016-05-17 | 112000 | 118000 |
| 003 | English_Movie | Horror | 2017-08-06 | 245000 | 360000 |
| 004 | Bengali_Movie | Adventure | 2017-01-04 | 72000 | 100000 |
| 005 | Telugu_Movie | Action | - | 100000 | - |
| 006 | Punjabi_Movie | Comedy | - | 30500 | - |
List MovieID, MovieName, and Cost for all movies with ProductionCost greater than 10,000 and less than 1,00,000.
Consider the following MOVIE table and write the SQL query based on it.
| MovieID | MovieName | Category | ReleaseDate | ProductionCost | BusinessCost |
| 001 | Hindi_Movie | Musical | 2018-04-23 | 124500 | 130000 |
| 002 | Tamil_Movie | Action | 2016-05-17 | 112000 | 118000 |
| 003 | English_Movie | Horror | 2017-08-06 | 245000 | 360000 |
| 004 | Bengali_Movie | Adventure | 2017-01-04 | 72000 | 100000 |
| 005 | Telugu_Movie | Action | - | 100000 | - |
| 006 | Punjabi_Movie | Comedy | - | 30500 | - |
List details of all movies which have not been released yet.
Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:
- Display the MatchID of all those matches where both teams have scored more than 70.
- Display the MatchID of all those matches where FirstTeam has scored less than 70 but SecondTeam has scored more than 70.
- Display the MatchID and date of matches played by Team 1 and won by it.
- Display the MatchID of matches played by Team 2 and not won by it.
- Change the name of the relation TEAM to T_DATA. Also, change the attributes TeamID and TeamName to T_ID and T_NAME respectively.
Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:
Display the MatchID of all those matches where FirstTeam has scored less than 70 but SecondTeam has scored more than 70.
Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:
Display the MatchID of matches played by Team 2 and not won by it.
Consider the following tables – Bank_Account and Branch:
Table: Bank_Account
| ACode | Name | Type |
| A01 | Amrita | Savings |
| A02 | Parthodas | Current |
| A03 | Miraben | Current |
Table: Branch
| ACode | City |
| A01 | Delhi |
| A02 | Mumbai |
| A01 | Nagpur |
What will be the output of the following statement?
SELECT * FROM Bank_Account NATURAL JOIN Branch;
______ clause is used with a SELECT statement to display data in a sorted form with respect to a specified column.
Write the outputs of the SQL queries (i) to (iv) based on the relations COMPUTER and SALES given below:
| Table: COMPUTER | ||||
| PROD_ID | PROD_NAME | PRICE | COMPANY | TYPE |
| P001 | MOUSE | 200 | LOGITECH | INPUT |
| P002 | LASER PRINTER | 4000 | CANON | OUTPUT |
| P003 | KEYBOARD | 500 | LOGITECH | INPUT |
| P004 | JOYSTICK | 1000 | IBALL | INPUT |
| P005 | SPEAKER | 1200 | CREATIVE | OUTPUT |
| P006 | DESKET PRINTER | 4300 | CANON | OUTPUT |
| Table: SALES | ||
| PROD_ID | QTY_SOLD | QUARTER |
| P002 | 4 | 1 |
| P003 | 2 | 2 |
| P001 | 3 | 2 |
| P004 | 2 | 1 |
SELECT MIN(PRICE), MAX(PRICE) FROM COMPUTER;SELECT COMPANY, COUNT(*) FROM COMPUTER GROUP BY COMPANY HAVING COUNT(COMPANY) > 1;SELECT PROD_NAME, QTY_SOLD FROM COMPUTER C, SALES S WHERE C.PROD_ID=S.PROD_ID AND TYPE = 'INPUT';SELECT PROD_NAME, COMPANY, QUARTER FROM COMPUTER C, SALES S WHERE C.PROD_ID=S.PROD_ID;
The code given below reads the following records from the table employee and displays only those records that have employees coming from the city 'Delhi':
E_code - StringE_name - StringSal - IntegerCity - String
Note the following to establish connectivity between Python and MySQL:
- Username is
root - Password is
root - The table exists in a MySQL database named
emp. - The details
(E_code,E_name,Sal,City)are the attributes of the table.
Write the following statements to complete the code:
Statement 1 - to import the desired library.
Statement 2 - to execute the query that fetches records of the employees/coming from the city ‘Delhi’.
Statement 3 - to read the complete data of the query (rows whose city is Delhi) into the object named details, from the table employee in the database.
import ____________ as mysql #Statement 1
def display():
mydb=mysql.connect(host="localhost",user="root"
passwd="root", database=" emp")
mycursor=mydb.cursor()
____________ #Statement 2
details = ____________ # Statement 3
for i in details:
print (i)Consider the tables PRODUCT and BRAND given below:
| Table: PRODUCT | ||||
| PCode | PName | UPrice | Rating | BID |
| P01 | Shampoo | 120 | 6 | M03 |
| P02 | Toothpaste | 54 | 8 | M02 |
| P03 | Soap | 25 | 7 | M03 |
| P04 | Toothpaste | 65 | 4 | M04 |
| P05 | Soap | 38 | 5 | M05 |
| P06 | Shampoo | 245 | 6 | M05 |
| Table: BRAND | |
| BID | BName |
| M02 | Dant Kanti |
| M03 | Medimix |
| M04 | Pepsodent |
| M05 | Dove |
Write SQL queries for the following:
- Display product name and brand name from the tables PRODUCT and BRAND.
- Display the structure of the table PRODUCT.
- Display the average rating of Medimix and Dove brands.
- Display the name, price, and rating of products in descending order of rating.
