how are rank and dense rank being alloted for column with same values over a par

how are rank and dense rank being alloted for column with same values over a particular column

Question Posted / shipra gupta

1 Answers
2416 Views
I also Faced
E-Mail Answers

how are rank and dense rank being alloted for column with same values over a particular column..

Answer / shipra gupta

salary R DR
800 1 1
800 1 1
200 3 2

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

how mysql optimizes distinct? : Sql dba

0 Answers

what is External tables? explain with examples

2 Answers TCS,

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers

can i use global variables in stored procedure or function

1 Answers L&T,

what is the difference between trigger and constraint?

3 Answers HSBC,

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers iGate, Wipro,

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

0 Answers

what is 'mysqlshow'? : Sql dba

0 Answers

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers

Why cross join is used?

0 Answers

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers

Can a table have no primary key?

0 Answers

For more SQL PLSQL Interview Questions Click Here