Hi Guest
HomePage
Java
DotNet
SEO
Agile
DataBase
Agile
API
CMS
Server
Testing
HR
Web
To improves our performance please Like Share Subscribe(Will boost us)
Follow
nth highest number from table
Question Posted on 30 Jun 2011
Home
>>
DataBase
>>
SQL Query
>>
nth highest number from table
Hi Put number in the place of nth
SELECT TOP 1 number
FROM (SELECT DISTINCT TOP 'nth' number
FROM EMPLOYEE ORDER BY number DESC) a
ORDER BY number ASC
0
0
Most Visited Questions:-
Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a
More...
What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript
More...
Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra
More...
Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres
More...
Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec
More...
Other Important Questions
How to get the table count in last used query from cache by sending tablename?
Write a SQL query to print 1 to 100 in sql server?
Sql Interview Latest Query questions asked on 30 dec 2020
nth highest number from table
some good sql query
Most Visited Questions
Top Searches:
asp net questions
vb net questions
sql query
uddl questions
class
javascript Questions
sharepoint interview questions and concept
silverlight questions and concept
wcf questions
beans
general knowledge
ajax questions
PHP
|
Biztalk
|
Testing
|
SAP
|
HR
|
Privacy policy |
Terms and Conditions
| Blog
If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)
Home
About Us
GroupChat
Sitemap
Feedback
Contact us