How to select top 5 coloumn from a table without using
coloumn name

Answer Posted / yunus

select top(5) * from tablename

Is This Answer Correct ?    5 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does <> symbol mean?

621


What is table valued function and scalar valued functions?

575


How many triggers are possible per table?

720


How to move database physical files in ms sql server?

604


What are the mathematical functions supported by sql server 2005?

649






What is federation member?

103


What is difference between materialized view and view?

597


Tell me what is log shipping?

669


When columns are added to existing tables, what do they initially contain?

716


What is set nocount on?

585


How do I start and stop sql server?

619


What are pages and extents? : SQL Server Architecture

643


What is filtered index?

731


Can we delete data from a view?

626


What is partitioned view?

597