Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > db2 > answers

Needed SQL

Newbie
  
Join Date: Oct 2007
Posts: 1
#1: Oct 16 '07
Suppose i have a employee table i need to pick up the persons with top 3 salaries.what query i should give?
Newbie
  
Join Date: Nov 2007
Location: Laren, Netherlands
Posts: 6
#2: Nov 2 '07

re: Needed SQL

Sort rows descending on salary and add the 'Fetch first 3 rows only' clause
Reply

« previous question | next question »

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,327 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved