set rowcount 5 select * from table

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

Question Posted / sudharshan

Answer Posted / sudharshan

set rowcount 5
select * from table_name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create function without parameter in sql server?

647

What are the lambda triggers?

568

How to change parameter value inside the report?

119

What are the advantages of using stored procedures in sql server?

587

Difference between DELETE and TRUNCATE?

699

What is the significance of null value and why should we avoid permitting null values?

621

What is attribute? : sql server analysis services, ssas

674

Explain following error properties?

636

What is the Disadvantage of indexed sequential file.

705

Write a sql query to sort on different column name according to the parameters passed in the function?

612

What is ssl in sql server?

630

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3898

Explain how to integrate the ssrs reports in application?

592

What is 3nf normalization form?

659

What are trace flags and mention a few common trace flags used with sql server?

639