Q51. Which operator searches text patterns?
`LIKE` with wildcards `%` (zero or more chars) and `_` (single char). ```sql WHERE name LIKE 'A%' -- starts with A WHERE name LIKE '%a%' -- contains a WHERE name LIKE '_a...
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 (142 available).
Active:
Tag: data ×
Q52. Details of students whose FirstName starts with 'K'?
To find records where a text column begins with a specific letter or prefix, use the **`LIKE`** operator with the `%` wildcard: ```sql SELECT * FROM Students WHERE FirstN...
Q53. Which operator selects values in a range?
The **`BETWEEN`** operator selects values within an inclusive range (numbers, text strings, or dates): ```sql SELECT product_id, name, price FROM products WHERE price BET...
Q54. 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.
Q55. 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...
Q56. 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...
Q57. What does UPPER do?
Converts to uppercase. `LOWER` to lowercase. `INITCAP` (Oracle/PostgreSQL) capitalizes first letter of each word. ```sql SELECT UPPER('hello'); -- HELLO ```
Q58. 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); ...
Q59. 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...
Q60. 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...