How to get Get the highest salary without using TOP clause
Are you looking for a way to Get the highest salary without using TOP clause ? then read this thread to know how to get it
Can any one please send me the answer of below question.
1. Get the nth highest salary without using TOP clause.
2. Why Having clause if we have the Where clause to filter the records.
3. Can we use the where clause with having clause
4. Is the Order By clause must for using the Having clause?
5. How the indexes works internally.
6. Why more than one Clustered index not allowed for a table.
7. Do you think that having more indexes degrades the performance of the query? Id so then why?