What is difference between rank () row_number () and dense_rank () in sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What are the different schemas objects that can be created using pl/sql?

0 Answers  


How to pipe multiline string to isql?

0 Answers  


What is procedure and function?

0 Answers  


I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,


Delete duplicate records in the emp table.

6 Answers   Oracle,






Describe types of sql statements?

0 Answers  


If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,


difference between SQL and C

1 Answers   Indus Software Technologies,


What are sql queries used for?

0 Answers  


How delete all data from table in sql?

0 Answers  


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  


Why do we use triggers?

0 Answers  


Categories