Question
A shopkeeper has 36 kg rice a part of it, he sells at
the profit of 32% and rest at loss of 16% and he get the loss of 12% so what is the quantity sold at the loss of 16%.Solution
Ratio = 4:44 = 1:11 Therefore, required answer = 36 x 11/12 = 33kg
To rename a column in a SELECT query result, you use:
Which SQL function returns the number of rows in a table?
SQL Injection can be prevented by all EXCEPT:
Which SQL keyword is used to remove duplicate records from a query result?
Which SQL constraint ensures a column cannot have NULL values?
Which of the following can be used to avoid duplicate entries in a column?
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
Which SQL clause is used to filter results after a GROUP BY operation?
Which SQL clause is used to filter records based on aggregate functions?
Which SQL statement combines the results of two queries and removes duplicates?