SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
how to find third highest record from table? how to find third highest record from table?

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 09-29-2006, 06:20 PM
davinder singh
 
Posts: n/a
Default SQL 92 dialect question:

how to find third highest record from table?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 09-30-2006, 03:40 AM
Dimitar
 
Posts: n/a
Default SQL 92 answer. Re: how to find third highest record from table?
Please, see my answer to question number 47 ([A]here[/a]), which assumed natural ordering on column "a".
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
  #3 (permalink)  
Old 10-13-2006, 12:03 AM
manithan
 
Posts: n/a
Default MS SQL answer. Re: how to find third highest record from table?
SELECT top 3 columnname FROM tablename
ORDER BY callsanswered DESC
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
  #4 (permalink)  
Old 12-19-2006, 11:57 AM
Dhanalakshmi
 
Posts: n/a
Default SQL 99 answer. Re: how to find third highest record from table?
SELECT TOP 1 *
FROM (SELECT TOP 2*
FROM tablename
ORDER BY columnname DESC)e1
ORDER BY Sal
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
Reply

« How do I sort results using ORDER BY? | How do I format mySQL date? »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Moderation Tools:


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find second highest value of a column in a table? ruby SQL - Questions and Answers 23 05-07-2008 05:51 AM
how to find out the 4th highest value from the column? Anoj biradar SQL - Questions and Answers 4 02-21-2008 07:24 AM
How to find second highest value of a column in a table? | SQL? jaheer SQL - Questions and Answers 10 07-24-2007 11:07 AM


All times are GMT. The time now is 07:29 AM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7