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

What are the dmvs?

558

how to overcome kernel isssues

1168

Can sql servers link to other servers?

557

What are different backups available in sql server?

599

What is dknf in normalization form?

553

How do I make a resultset scrollable?

496

What are the different types of subquery?

608

What is normalization 1nf 2nf 3nf?

624

What is the use of sign function?

555

What is the contrast between sql and pl/sql?

620

Can two tables share a primary key?

510

Describe in brief databases and sql server databases architecture.

521

How to achieve Paging of records in SQL SERVER?

590

what's sql server? : Sql server database administration

492

Does sql server 2000 full-text search support clustering?

499