SELECT TOP(3) * FROM emp ORDER BY EId DESC

wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records

Question Posted / lakram5455

Answer Posted / lakram5455

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is difference between view and materialized view?

937

What is update locks?

887

Why do we backup Active Directory ?

1042

How to how to convert numeric expression data types using the convert() function??

1051

How to delete existing rows in a table?

1160

What is 2nf normalization form?

1136

What is Sqlpaging in SqlServer 2005 ?

1066

What is bcp? When does it used?

976

What is service broker?

1005

How to copy the tables, schema and views from one sql server to another?

1047

What is the difference between rank and dense_rank?

1089

What is database architecture? : SQL Server Architecture

1044

what is hash nonclustered index

969

How to convert a numeric expression from one data type to another?

1016

What do you understand by mirroring?

997