Post New Resource

Get the Random Records from a Table

Posted By :Lakhan Pal Garg Posted Date :09/05/2010 Points :10 Category: SQL Query URL: http://lakhangarg.blogspot.com

Query to Get the Random Records from a Table in a Database

Query to Get the Random Records from a Table in a Database.
Supoose we want to show 5 Random News on main page of the website.
Example:
Table Name:tblNews
Columns: NewsID,Description,DatePosted

SELECT TOP 5 NewsID,Description,DatePosted FROM tblNews ORDER By NEWID()

OUTPUT: 5 News will be fetched from table at Random. each times 5 different news will be picked from the table.

Thanks & Regards
Lakhan Pal Garg

Featured Articles

Best Practices No 5: - Detecting .NET application memory leaks
Memory leaks in .NET application have always being programmer's nightmare. Memory leaks are biggest problems when it comes to production servers. Productions servers normally need to run with least down time. Memory leaks grow slowly and after sometime they bring down the server by consuming huge chunks of memory. Maximum time people reboot the system, make it work temporarily and send a sorry note to the customer for the downtime. ... Read More

.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
One of the important factors for performance degradation in .NET code is memory consumption. Many developers just concentrate on execution time to determine performance bottle necks in a .NET application. Only measuring execution time does not clearly give idea of where the performance issue resides. Ok, said and done one of the biggest task is to understand which function, assembly or class has consumed how much memory. In this tutorial we will see how we can find which functions consume how much memory. This article discusses the best practices involved using CLR profiler for studying memory allocation.... Read More

How to improve your LINQ query performance by 5 X times ?
LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. ... Read More

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply

Read also another Resources from the same Author Copy Directory from one location to other Recursively Implement Multilingual in ASP.NET Web Site using globalization. Write Data into a MS-Word Document Create thumbnail of a Image Get Values of a Column in a Single Variable	Related Resource From The Same Category encrypt field value in sql server using PWDENCRYPT Get top records from sql query Convert expression into LOWER / UPPER case in sql Get the column Length of a table in sql. Get current date In sql server ,oracle and MYSQL

Find More code samples in C#, ASP.Net, Vb.Net and more Here

Get the Random Records from a Table

Featured Articles

Read also another Resources from the same Author

Related Resource From The Same Category