hi all ,
how r u ???
in My Query .
if i write this query , it give me the First top 10 Post Written By Only One User !! and it should Give Me top 10 Post By different Users not only one user.
assume that this is My Table :
when i write above Query :
it give me the First 10 Post Written By User1 only , althougth the top 10 Post Written By Different Users From User1 to User10
this is mean there is some thing wrong with relationship Between two Tabel???
if i Order My Query By Using Order By PostID desc ....it give me Exact Resluts but the query seem to too slowly
You cannot guarantee the order of data without using the ORDER BY command. So, if you need a particular set of data in your TOP 10 query, you must use ORDER BY.
If you're seeing the query running slow because of ORDER BY you might be able to create an index on the table that will help.
You can use an execution plan to understand what's happening with your query and where you might be able to apply the index.
answered Feb 29 '12 at 05:48 PM
Grant Fritchey ♦♦