Record

RECORD

Each record represents complete information of the specific data item, each record stores different data with the same structure

Example : For example in an employee table, we need to store the details of 10 employees then the database table will consist of 10 records every each record contains details of that particular employee i.e 1 record for storing the information of one employee

Consider a sample table ‘emp’

Table contents seven rows i.e it stores the details of all the 7 employees in 7 separate records

SQL Query to retrieve particular records

SELECT * FROM EMP
WHERE DEPTNO=20;

Output :
4 rows selected.

Only those rows corresponding to the details of Department number 20 are displayed

ROW NUM in SQL

• The rownum clause  in SQL is used to specify the number of rcords present in a database table
• Each record will be added a number starting from 1 to n so that the user can easily identify the number of records present in the table

Example

select rownum,empno,ename,job,sal,deptno 
FROM EMP;

Output :
7 rows selected.

Displaying top N records

Suppose if you want to display the top three records present in emp table then you can use this rownum along with the relational operator

Example

select rownum,empno,ename,job,sal,deptno 
FROM EMP
where rownum<=3;

Output :
3 rows selected.

Only the first 3 records in a table or displayed