adspace


What is dense_rank?

Answer Posted / Vipnesh Sharma

"dense_rank() in SQL/PLSQL is a window function that assigns consecutive integers to each row within a partition, without any gaps."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is collation? : Sql dba

1229


How do I remove duplicates in two columns?

1184


Does group by remove duplicates?

1112


Can delete statement be rollbacked?

1053


what are all the common sql function? : Sql dba

1131


define sql insert statement ? : Sql dba

1098


If a cursor is open, how can we find in a pl/sql block?

1236


Is inner join faster than left join?

1274


What is the best sql course?

1050


what is bcp? When does it used? : Sql dba

1055


what is dbms? : Sql dba

1061


what is sql server agent? : Sql dba

1182


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

1111


Is primary key clustered index?

1018


What is the current version of postgresql?

1177