HCL Infosystems Lead Software Engineer Interview Questions and Answers

Program to print the Fibonacci series up to a given number.

• Take input from user for the limit of the series.

• Initialize two variables with 0 and 1 respectively.

• Use a loop to generate the series and print each number.

• Add the previous two numbers to get the next number in the series.

To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

• Use the ORDER BY clause to sort the table in descending order.

• Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

• Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;