Question
Which SQL keyword prevents duplicate rows in result?
More SQL Questions
- Which query returns departments whose average salary is greater than 60000?
- A table has salaries 90000, 90000, 85000, 80000 (sorted descending). Using RANK() OVER (ORDER BY Salary DESC), what ranks are assigned, and how does this d...
- Which of the following is true about a foreign key?
- A table T has a column Marks with the values 10, 20, NULL, 20, 30. What is the result of: SELECT COUNT(*) + COUNT(DISTINCT Marks) + AVG(Marks) FROM T;
- Employees(emp_id, name, salary, mgr_id): (1,'Alice',9000,NULL), (2,'Bob',7000,1), (3,'Carol',9500,1), (4,'Dave',6000,2). What does the following self-join ...
- Table Orders(OrderID, CustomerID) has 10 rows with CustomerID values: C1, C1, C2, C3, C1, C2, C4, C2, C3, C1. How many groups (customers) will be returned ...
- Which SQL function is used to calculate the average of a numeric column?
- What is the main function of a "foreign key" in a relational database table?
- A 'view' in SQL is best described as:
- Which SQL command permanently removes both the stored data and the entire structural definition (columns, constraints, indexes) of a table from the databas...
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)