the RANK() and DENSE_RANK() functions can be used to determine the LAST N

How do you retrieve the last N records from a table?

Question Posted / manas ranjan

Answer Posted / manas ranjan

the RANK() and DENSE_RANK() functions can be used to
determine the LAST N or BOTTOM N rows.

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

List the ways to get the count of records in a table?

942

What is the difference between a subquery and a join?

1173

What is a heap in sql?

1146

what is sql in mysql? : Sql dba

1238

What pl/sql package consists of?

1135

What are the properties of a transaction?

1185

how to use regular expression in pattern match conditions? : Sql dba

1089

Is sql sequential or random?

1086

What is forward declaration in pl sql?

1141

which operator is used in query for pattern matching? : Sql dba

1045

What does select top 1 do in sql?

1142

Explain what is rdbms?

1086

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1056

What is crud diagram?

993

What is the difference between having clause and where clause?

1113