Interested to Buy Any Domain ? << Click Here >> for more details...
Write a sql query to find n'th maximum in the database
table.
- 3 Answers
- 11018 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 |
Write a code snippet to display an integer in a binary format?
You have been asked to install a servlet engine (tomcat, glassfish, etc.) for a companies servlets. Assuming the company has an existing web/DBMS server (which may or may not be on the same server), explain in detail how would you implement the development project and a deployment solution.
Write a program to Print the Pascal triangle
Write a Program to find the sum of digits of a given number until the sum becomes a single digit. (e.g. 12345=>1+2+3+4+5=15=>1+5=6)
Main frame : I have a PS file. 4 records. I need toread a particular field of that file and then add it up. then write the added field along with all other fields
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.
1.What type of material can be sent from a Java servlet to a browser ? How does the browser know how to deal with the material? 2.Explain what happens to a servlet when a servlet engine is sent a GET request.
In LSMW , what does the following error mean and how to rectify it : Incorrect interface data for set 78 in method C . This error is occuring in idoc processing step of LSMW.
Write a Program for matrix multiplication.
Write a Program to find the number of words in a sentence.
Write a sql query to find n'th maximum in the database table.
Write code that allows to create only one instance of a class?
C Code 
