Nth Highest Salary in SQL. Fetch Duplicate records in SQL. Write shell script to print febonicci series.

Question

Accepted Answer

SQL query to find Nth highest salary, fetch duplicate records, and shell script for Fibonacci series.

To find Nth highest salary in SQL, use the 'ROW_NUMBER()' function with 'ORDER BY' and 'LIMIT'. Example: SELECT salary FROM (SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rn FROM employees) AS temp WHERE rn = N;
To fetch duplicate records in SQL, use the 'GROUP BY' and 'HAVING' clauses. Example: SELECT column1, column2, COUNT(*) FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1;
To write a shell script for Fibonacci series, use a loop to calculate the next number based on the previous two numbers. Example: a=0 b=1 for ((i=0; i

Top Telecall Technology Application Support Engineer interview questions & answers