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

Answer Posted / varun

select column_name from table_name 997,1000

Is This Answer Correct ?    1 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what are acid properties?

568


tell me the disaster recovery plan

2021


What is a view in sql?

578


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

541


What have included columns when we talk about sql server indexing?

572






What is the difference between stored procedure and functions?

593


Mention the command used to rename the database.

532


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1626


When I delete any data from a table, does the sql server reduce the size of that table?

580


What is model database? : SQL Server Architecture

568


Do you know what is rank function?

619


What is difference between unique and primary key?

479


Can select statements be used on views in ms sql server?

580


What is extended stored procedures?

563


How to link tables in sql server?

473