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 are the purpose of Normalisation?

1020

What is the function of inner join?

1026

What is the difference between online clustering and Offline clustering?

2386

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

948

Explain what you mean by 3 tier architecture.

1041

What are the different types of backups that exist?

1130

What is query and its types?

889

List out what other servers you can use with ssrs?

135

What do you mean by cardinality?

872

Explain the difference between functions and stored procedures in sql server?

941

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1037

What are xml indexes?

914

What does it mean to invest in the index?

929

Explain in brief about Microsoft SQL server?

1044

What do you mean by tablesample?

1051