Hi, I am retrieving some records from a table. I am using select statement with order by clause and also distinct keyword. Every time getting records randomly not in one order when ever I execute the select statement. This is happend on Production database only. When I run the same query on development server, there is no issues. What I need to do to get records every time in one order. Please help me in this. Thanks in-advance.