You have a query that returns a list with employees. You want to add a column to your query that displays a sequential number for indentification purposes. Which of the following functions can be used?

You have a query that returns a list with employees. You want to add a column to your query that displays a sequential number for indentification purposes. Which of the following functions can be used?

You have a query that returns a list with employees. You want to add a column to your query that displays a sequential number for indentification purposes. Which of the following functions can be used?


Answer:- The ROW_NUMBER function

 (You should use the ROW_NUMBER function because it will automatically add a sequential number to every resultset returned.)