Process N record from each group | SQL Server

 

ROW_NUMBER() function in SQL Server is very useful special in case when you want to process N records from a specific group. This function has been around since SQL Server 2005 and at its core, provides a way to provide sequential numbering for rows returned by a query.

As well as sequential numbering, ROW_NUMBER() provides a way to partition the results returned so this suited me just fine

Table Structure 

Descriptive Answer : NIELIT IT Tools and Business Systems (July 2018)

Q. 5 (A) :  Write a short note on storage devices of computer.
Answer : 

Examples of Storage Device

Answer : IT Tools and Business Systems (January 2019)

Q. 5 (A) : Explain about Multitasking operating system in detail.

Answer :

Multitasking, in an operating system, is allowing a user to perform more than one computer task (such as the operation of an application program) at a time. The operating system is able to keep track of where you are in these tasks and go from one to the other without losing information. Microsoft Windows 2000, IBM's OS/390, and Linux are examples of operating systems that can do multitasking (almost all of today's operating systems can). When you open your Web browser and then open Word at the same time, you are causing the operating system to do multitasking.

Descriptive Question Answer NIELIT (O-Level ) IT Tools and Business Systems (July 2019)

Answer IT Tools and Business Systems (July 2019)

Q 5 (A) . Define Computer. Explain the main characteristics of Computer.

Answer :

Computer

A computer is an electronic device that manipulates information, or data. It has the ability to store, retrieve, and process data. You may already know that you can use a computer to type documents, send email, play games, and browse the Web. You can also use it to edit or create spreadsheets, presentations, and even videos.