Database test

Question

Comments

D is given

---

Ya it is going to be D.Just go through the link which I have mentioned and read the most voted answer.I hope it will clear your doubts if any

---

Thanks

Answer 1

Here the main confusion that is created is between option B and D.

As we know SELECT statement can return duplicates , so is the case here.

Suppose u have 6 values 1,2,3,4,5,5 then the query mentioned in option B will return all the 6 tuples i.e. 5,5,4,3,2,1 whereas if you use query mentioned in option D , it will return 5,4,3,2,1.

Plz consult this link :(This may help you further and remove any further doubt if you have)

http://stackoverflow.com/questions/20853725/what-is-the-use-of-with-ties-keyword-in-select-statement-in-sql-queries

Hence the correct option to the above question would be option D.

Comments

I dont agree with you. 5,5 will be considered in both bcoz Top with ties and Top differ only if last item has duplicate.

---

That is why I m saying u have to consider all cases.A case may occur where last item may have duplicates.In that case B) option would be wrong

Answer 2

Option B is Correct 

for functionality of TOP with TIES

refer http://stackoverflow.com/questions/20853725/what-is-the-use-of-with-ties-keyword-in-select-statement-in-sql-queries

Comments

@habibkhan

pls read the link again

---

Read all the answers properly . WITH TIES along with ORDER BY clause is not removing duplicacy I agree but WITH TIES along with ORDER BY DESC is removing duplicacy.

---

Ya I have checked.I request you to read the answer by Adriaan Stander which is most voted.There also it is written.

Answer 3

D is correct B has wrong syntax after from its missing orders collumn name rather it writes orderby directly.
optin c will not give the answer sorted hence top 5 can be any value