Selecting records using QUALIFY in Teradata

Using Qualify, you can select particular records from a table.

Consider the following table student,

If you want to select the second record from the bottom then,

SELECT * FROM student QUALIFY RANK(id) =2;

Then the output will be,

id	name
4	u

If you want to select the second record from the top most then,

SELECT * FROM student QUALIFY RANK(id ASC) =2;

Then the output will be,

id	name
2	s

Contribute to Forget Code, help others. Add snippet