Write a sql query to find n'th maximum in the database
table.
- 3 Answers
- 9821 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sabarish
This is to find max value in a column.
select max(<column_name>) from <table_name> ;
| Is This Answer Correct ? | 17 Yes | 6 No |
Answer / srikar
This is to find nth max in the table.
select min(<column_name>) from <table_name> where
<column_name> in (select distinct top n * from <table_name>
order by <column_name> desc)
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / laxman
show tables;
this is wrkg in myql
it will show all the tables in row wise so u can easly find out
| Is This Answer Correct ? | 2 Yes | 2 No |
Devise a program to implement the Fibonacci sequence.
DAL in oracle
Design a timer circuit using VHDL which has the following: input : start_timer(ST) output: long_time(LT) short_time(ST) when the timer is triggered by the ST(either 0 or 1) signal the timer should generate two timing signals accordingly.While the long time is going ON the other should be OFF and vice versa.
Write a program that implements a date class containing day, month and year as data members. Implement assignment operator and copy constructor in this class.
Write a Program to find the reverse of a given number.
Write a sql query to find n'th maximum in the database table.
i wrote from two tables (employee and department) 1.select * from employee,department; (it is cartesian product) but 2.select * from employee department; (?????????????????) by default it displays the employee table,what is the reason it is not taking department ??? mail @ mak2786@gmail.com Arunkumar
how to test the orientation of the layout in android.to note any changes in the ui design when change orientation
Write a Program to find the number of words in a sentence.
find out the list of users who have access to all t-codes starts with 'SU'? thanks in advance all.
I have a file which contains so many lines and variable number of lines are treated as a record. For example *first ooooo xxxxx ttttt mmmm vvvvvvv *end uuu bbbb *first kkkkvvvvvv nnnn mmmmm kkkkk fffff gggg ffff kkkk lllll *end. Here the lines from *first to *end are treated as a record. The number of lines between *first and *end is not same for all the records. Suppose there are 100 records (or number of records are not predefined)like the format given in the above example. Now the entire file needs to split into two files, first having 40 and remaining in the second file. Can we split using sort utility? If possible then what is the sort card?
How many digit have a Polaris 1995 300c.c. 2x4 nad how many have a Polaris 2007 300 c.c 2x4? And what site I can check this information???
C Code 
