Q31. Correct syntax for date range?
```sql SELECT * FROM Sales WHERE Date BETWEEN '2017-12-01' AND '2018-01-01'; ``` Use ISO-8601 format (`YYYY-MM-DD`) to avoid locale issues.
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (119 available).
Active:
Tag: sql ×
Q32. LastName alphabetically between "Brooks" and "Gray"?
To select records alphabetically between two string boundaries, use the `BETWEEN` operator: ```sql SELECT * FROM Customers WHERE LastName BETWEEN 'Brooks' AND 'Gray' ORDE...
Q33. What does the IN keyword do?
Checks if a value matches any in a list. It's a shorthand for multiple ORs and often more readable. ```sql -- These are equivalent: WHERE state IN ('CA', 'NY', 'TX') WHER...
Q34. What does UPPER do?
Converts to uppercase. `LOWER` to lowercase. `INITCAP` (Oracle/PostgreSQL) capitalizes first letter of each word. ```sql SELECT UPPER('hello'); -- HELLO ```
Q35. Round up to the nearest integer?
To round a numeric value up to the next nearest integer, use the **`CEIL()`** (or **`CEILING()`**) function: ```sql SELECT CEIL(25.01); -- Returns 26 SELECT CEIL(25.00); ...
Q36. Current date in MySQL without time?
In MySQL, you retrieve the current date (year, month, day) without the time component using **`CURDATE()`** or **`CURRENT_DATE`**: ```sql SELECT CURDATE(); -- Example: '2...
Q37. Keyword to retrieve maximum value?
The keyword and aggregate function used to retrieve the maximum value of a column is **`MAX()`**: ```sql SELECT MAX(salary) AS highest_salary FROM employees; ``` ### With...
Q38. Function to count results?
`COUNT()`. `COUNT(*)` counts rows. `COUNT(column)` counts non-NULL values. ```sql SELECT COUNT(*) FROM orders; -- Total orders SELECT COUNT(shipped_date) FROM orders; -- ...
Q39. Which are aggregate functions?
**Aggregate functions** perform a computation on a set of values across multiple rows and return a single summarizing value: ### Core Standard Aggregate Functions: 1. **`...
Q40. Return number of records in Customers?
To return the total count of rows in the `Customers` table, use **`COUNT(*)`**: ```sql SELECT COUNT(*) AS total_customers FROM Customers; ``` ### `COUNT(*)` vs `COUNT(col...