Question
Which of the following SQL constructs avoids returning duplicate rows?
More SQL Questions
- Transaction T1 runs 'SELECT COUNT(*) FROM Orders WHERE Amount > 1000' twice within the same transaction. Between the two reads, T2 inserts a new qualifying...
- Which single SQL constraint, when applied to a column, automatically enforces both uniqueness of values and a NOT NULL restriction, and is also used to uni...
- A table T has exactly 10 rows. Its column X contains 3 NULL values among its 10 entries, and of the remaining 7 non-null values, exactly two are duplicates...
- Materialized views differ from normal views because:
- A 'view' in SQL is best described as:
- Consider the table Employees(EmpID, Name, Dept, Salary). What will the following SQL query return? SELECT Dept, COUNT(*) FROM Employees GROUP BY Dept HAVI...
- Which SQL aggregate function returns the number of rows in a column that contain a non-NULL value, ignoring NULL entries in that column?
- Table T(A,B) contains: (1,NULL), (NULL,2), (3,4), (NULL,NULL). How many rows are returned by the following query? SELECT * FROM T WHERE A=3 OR B=4;
- Which SQL command is used to modify existing records in a table?
- Which SQL command removes all rows from a table very quickly (typically without generating per-row log entries) while preserving the table's structure, and...
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)