•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,416 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,310 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 1605 | Replies: 1
 |
•
•
Join Date: Nov 2006
Location: Mumbai
Posts: 10
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
sql syntax - Copy table Can anyone please tell me how can i copy a table.
thank you.
and also how to fin out the second highest value of a field in a table. eg. select the employee cashing in the second highest salary in the company.
Thanks a lot.
thank you.
and also how to fin out the second highest value of a field in a table. eg. select the employee cashing in the second highest salary in the company.
Thanks a lot.
•
•
Join Date: Jan 2008
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
You can select the second highest value using a subquery:
--------------------
http://www.ahewd.com
select top 1 * from (select top 2 * from employee order by salary desc) as tmp order by tmp.salary
http://www.ahewd.com
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ajax asp business colour copy copyright database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development fax google gpt guid partition table hacker highlighting lawsuit management studio 2005 microsoft msdn news office partition scan security software sql sql cache dependency with polling-based invalidation survey syntax vista
- DataAdapter problem with MS-Access (C#)
- Open In New Window Php (PHP)
- Create View syntax problem (Oracle)
Other Threads in the MS SQL Forum
- Previous Thread: How to find thrid maximum value from a table
- Next Thread: StoredProcedure @variable = table.field not working
