Select 10 rows from a table ? Answer : Use TOP keyword to select 10 ro

1. What are the grouping function in SQL ?

2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?

3. Difference between DROP, DELETE, TRUNCATE table ?

4. What is constraints and types ?

5. What is max size of nchar & nvarchar ?

6. Define ROLLBACK, COMMIT, SAVE POINT

7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise

8. Select 10 rows from a table ?

9. Define DML, DDL, DCL, DTL commands ?

10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?

11. Default constraints ?

12. Can we have more then primary Key in table ?

13. Type of integrity ? Entity, Referential, Domain ?

Question Posted / srivas

10 Answers
18444 Views
Perot Systems, I also Faced
E-Mail Answers

Answer Posted / srivas

Select 10 rows from a table ?

Answer : Use TOP keyword to select 10 rows from a table.

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

can an order by clause be used in a creation of a view?

1153

Explain Capacity planning to create a database? and how to monitor it?

4177

How will you know when statistics on a table are obsolete?

1063

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

885

What is linked report?

129

What is transactional replication?

943

What is data file in computer?

924

What is the definition for sql server 2000?

1073

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2002

Is it ok to shrink transaction log?

977

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1014

What type of Index will get created after executing the above statement?

1076

Are semicolons required at the end of sql statements in sql server 2005?

964

How do I determine how many instances of sql server are installed on a computer?

982

What do you understand by triggers?

897