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
18524 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

How to apply filtering criteria at group level with the having clause in ms sql server?

993

How many cores do I need for sql server 2016?

890

Define outer join in sql server joins?

925

What are the differences between stored procedure and view in sql server?

1234

Explain about link server in sql server?

1050

What is acid mean in sql server?

1110

How many types of objects are there?

998

What is the difference between DATETIME2 and DATETIME?

1070

How to name query output columns in ms sql server?

958

What is linked report?

131

How to add code to the existing article (using improve article)?

1099

What do you understand by SQL*Net?

1013

What is triggers in ms sql server?

1106

what are the different types of SSRS reports?

151

Is sql server 2016 free?

930