i want a Query for selecting of Table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

hi a have this table
My table name is NEWS
and this fields: NewsId ,NewsTitle,NewsDate
a want get a query
by select
a want select 3 record of this table
this 3 record is 3 last news by date
i want get 3 record of end of table (3 record of end time,not of end table)
please give me a query

Posted 6-Jun-12 10:09am

sadegh_rusta

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Stephen Hewison · Accepted Answer · 2012-06-06T10:13:00

Solution 1

Here you go:

SQL

SELECT TOP 3 NewsId, NewsTitle, NewsDate FROM NEWS ORDER BY NewsDate DESC

The following orders the results so the newest are at the top:

SQL

ORDER BY NewsDate DESC

The following instructs the SELECT to get just the first 3 rows:

SQL

SELECT TOP 3

Posted 6-Jun-12 10:13am

Stephen Hewison

Updated 6-Jun-12 10:14am

v2

Comments

sadegh_rusta 6-Jun-12 16:20pm

ok,
thx
if i want get 3 record of end of table !!!!!

thatraja 6-Jun-12 16:22pm

Try ORDER BY NewsDate ASC

sadegh_rusta 6-Jun-12 16:33pm

ok

Maciej Los 6-Jun-12 18:31pm

Good work, my 5!

VJ Reddy 10-Jun-12 5:04am

Good answer. 5!

Maciej Los · Accepted Answer · 2012-06-06T12:34:00

Solution 2

You can use a simple trick to get last 3 records in ascending order.

SQL

SELECT *
FROM (SELECT TOP 3 NewsId, NewsTitle, NewsDate FROM NEWS ORDER BY NewsDate DESC) AS DT
ORDER BY DT.NewsDate

Posted 6-Jun-12 12:34pm

Maciej Los

Comments

VJ Reddy 6-Jun-12 19:52pm

Nice answer. 5!

Maciej Los 7-Jun-12 3:11am

Thank you, VJ ;)