| ZS Associate |
3 (9LPA) |
You have a table sales(sale_id, product_id, sale_date, amount) and products(product_id, category). Find categories where sales in 2023 increased compared to 2022 |
| ZS Associate |
3 |
You have a table, logins(user_id, login_date). Find all users who have logged in for at least 3 consecutive days at any time (show user_id and first day of such a streak). |
| Tredence |
3 |
there is table transcation where we have all the transcation details.. find out top 5 customers by spending.. From this top 5 give me customer at index 2 and 3 |
| Tredence |
3 |
id val |
| 1 A |
|
|
| 1 A |
|
|
| 2 A |
|
|
| 2 B |
|
|
| 3 B |
|
|
| 3 B |
|
|
| 4 A |
|
|
| 4 A |
|
|
| Write a query to find out id which are associate with only one value |
|
|
| Tredence |
3 |
Write an Oracle SQL query to retrieve the top 2 highest-paid employees from each department. |
| Delloite |
3 |
Write a query to find the most recent order placed by each customer, including the ORDER_ID, ORDER_DATE, and TOTAL_AMOUNT. |
| Impetus |
3 |
Write a SQL Query to give output like that from Input like below - |
| Input |
|
|
| 1 |
|
|
| 2 |
|
|
| 3 |
|
|
| Output |
|
|
| 1 |
|
|
| 2 |
|
|
| 2 |
|
|
| 3 |
|
|
| 3 |
|
|
| 3 |
|
|
| Impetus |
3 |
eid ename status ptime |
| 1 a in 10:00 |
|
|
| 2 b in 11:00 |
|
|
| 1 a out 11:00 |
|
|
| 2 b out 11:30 |
|
|
| 3 c in 11:00 |
|
|
| 1 a in 12:00 |
|
|
| Write a Query to find out the employee who are in the office. |
|
|
| Impetus |
3 |
write query to find out 2nd highest salary without limit or top |
|
3 |
Employee_ID [8,7,8,8,8,7,7,8,8,7]add 10 where Employee_ID is 8 and subtract 5 where Employee_ID is 7 . In single statement |
|
3 |
Need to find out data which is present in Employee_stg table but not present in Employee_Tgt table. |
| Employee_stg (id,name) (1 John) (2 Patrick) (3 Samson) |
|
|
| Employee_Tgt (id name) (1 John) (2 Patrick) (3 Sameer) |
|
|
|
|
|
|
|
|
|
|
|