Shell scripts and optimized SQL queries
Filed under Amdocs
The question
Write shell scripts to display file names missing a specific name, write an optimized SQL query to find the fourth-highest salary without nested queries, and explain TOP/LIMIT and RANK vs DENSE_RANK.
No write-up yet. Related questions below have one.
Related Amdocs questions
Collected from public candidate posts and coding forums. Updated Nov 2026.