Answer / Shalendra Singh

In SQL, Rownum, Rank, and Dense_Rank are functions used for ordering result sets. Here are the main differences:nn1. Rownum - Returns a unique row number for each record in a query result set. It starts counting from 1 regardless of any sorting.n2. Rank - Assigns a ranking value to each record based on an order specified in the query. If there are ties, Rank assigns the same rank value to the tied records.n3. Dense_Rank - Similar to Rank but treats ties as separate ranks by incrementing the ranking number for each tie. This results in no gaps in the ranking sequence.

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1 Answers  

---

Explain the difference in execution of triggers and stored procedures?

1 Answers  

---

i need department wise top 2 employees salary.which logic i will use

17 Answers  

---

Explain what is sql*plus?

1 Answers  

---

which types of join is used in sql widely? : Sql dba

1 Answers  

---

What is data profiling in sql?

1 Answers  

---

Write a query to display the current date in sql?

1 Answers  

---

is mysql query is case sensitive? : Sql dba

1 Answers  

---

How do you declare a user-defined exception?

1 Answers  

---

What is intersect?

1 Answers  

---

How to write pl sql program in mysql command prompt?

1 Answers  

---

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

---