Question
Which operator is used for pattern matching in SQL?
More SQL Questions
- 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 ...
- Which SQL keyword prevents duplicate rows in result?
- A table has a B-tree index on the 'Name' column. Which of the following queries is LEAST likely to benefit from this index?
- Table Employee(EmpID, ManagerID) has 6 rows: (1,NULL), (2,1), (3,1), (4,2), (5,2), (6,3). How many rows will the following self-join return? SELECT E.EmpI...
- For the table Employees(EmpID, Name, Dept, Salary), which SQL query correctly retrieves all employees who earn more than the average salary of their own de...
- Which SQL keyword is used to eliminate duplicate rows in a query result?
- Which of the following SQL constructs avoids returning duplicate rows?
- 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;
- A column named Salary in a table contains the values 50000, NULL, 60000, and 70000. What value will the SQL expression AVG(Salary) return for this column?
- Which SQL function returns the number of rows in a table?
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)