CSE :: SQL Basics
-
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
prints -
The SQL statement
SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;
prints -
The SQL statement
SELECT ROUND(45.926, -1) FROM DUAL; - Which of the following must be enclosed in double quotes?
- Which of the following command makes the updates performed by the transaction permanent in the database?
- Which command undo all the updates performed by the SQL in the transaction?
- Find all the cities whose humidity is 89
- Find the temperature in increasing order of all cities
- What is the meaning of LIKE '%0%0%'
- Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy
Whatsapp
Facebook
|
A.
SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); |
|
B.
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); |
|
C.
SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); |
|
D.
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); |