Answer / rekha

select top 100 (field name)from table name order by (field
name) desc

Answer / zulfikar ali

SELECT TOP 100 FIELD_NAME
FROM TABLE_NAME
ORDER BY FIELD_NAME DESC

Answer / veeresh kethari

set rowcount 100
select * from tablename

Answer / veeresh kethari

SET ROWCOUNT 100

SELECT * FROM TABLENAME

Answer / karthi

select top 100 fieldname from tablename

Answer / ashis dey

select top 100 fieldname from tablename group by fieldname

Answer / vikas

select top 100 max(field name) from Table Name

Do you know how to make remote connection in database?

1 Answers  

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

What are cursors and when they are useful?

1 Answers  

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1 Answers   HCL,

What is rtm version in sql server?

1 Answers  

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

What do you do in data exploration

1 Answers   EXL,

What is the beast way to write CTE in SQL Server ?

1 Answers   HCL,

What is difference between count (*) and count 1?

1 Answers  

Magic Tables ?

2 Answers   Thomson Reuters,

Why should we go for stored procedures? Why not direct queries?

1 Answers  

Explain “not null constraint” in sql server?

1 Answers