How to get max 100 values from sql server
Answers were Sorted based on User's Feedback
Answer / rekha
select top 100 (field name)from table name order by (field
name) desc
| Is This Answer Correct ? | 14 Yes | 6 No |
Answer / zulfikar ali
SELECT TOP 100 FIELD_NAME
FROM TABLE_NAME
ORDER BY FIELD_NAME DESC
| Is This Answer Correct ? | 9 Yes | 1 No |
set rowcount 100
select * from tablename
| Is This Answer Correct ? | 4 Yes | 3 No |
SET ROWCOUNT 100
SELECT * FROM TABLENAME
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / ashis dey
select top 100 fieldname from tablename group by fieldname
| Is This Answer Correct ? | 0 Yes | 4 No |
ow to bring suspect mode datbase online from scratch
What are the basic functions for master, msdb, model, tempdb databases?
what are the problems in logshipping?
What is subquery? Explain the properties of a subquery?
How to create a user to access a database in ms sql server using "create user" statements?
How to enable tcp/ip protocol on a sql server?
Is sql server difficult to learn?
Define the one-to-one relationship while designing tables.
How many types of objects are there?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What are the restrictions that views have to follow? : SQL Server Architecture
What are entities and relationships?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)