Question
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
More SQL Questions
- Which SQL operator is used to search for a pattern in a column?
- ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
- Which type of trigger fires once for each row affected by the triggering DML statement?
- Which of the following can be used to avoid duplicate entries in a column?
- Which SQL constraint ensures a column cannot have NULL values?
- Which SQL clause is used to group rows?
- Which of the following statements about SQL `INDEXES` is generally TRUE?
- What is a 'stored procedure' in SQL?
- Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
- Which of the following is true about a foreign key?
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)