adspace


What is rownum in sql?

Answer Posted / Preetik Singh

"Rownum in SQL is an Oracle-specific pseudocolumn used to retrieve sequentially numbered rows returned by a query. It can be used for limiting the number of rows returned, sorting results, or skipping certain rows."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does group by remove duplicates?

1112


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

1113


What is the best sql course?

1050


what is collation? : Sql dba

1229


Is inner join faster than left join?

1277


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

1056


Is primary key clustered index?

1019


how to escape special characters in sql statements? : Sql dba

1114


how many tables will create when we create table, what are they? : Sql dba

1144


what is dbms? : Sql dba

1061


What is the current version of postgresql?

1178


Can we rollback truncate?

1074


define sql insert statement ? : Sql dba

1098


Is primary key always clustered index?

1095


Do we need to rebuild index after truncate?

1138