Answer Posted / sudip chatterjee
If the table is salary.then
SELECT * FROM salary ORDER BY income DESC LIMIT 1, 1;
here income is one attribute of salary table......
just use it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is sql scripting language?
What is full join?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is a nested table in word?
How does postgresql compare to oracle/db2/ms sql server/informix?
what is the syntax for using sql_variant_property? : Transact sql
what is timestamp in mysql? : Sql dba
What is nvl?
What do you mean by rowid?
How many commands are there in sql?
What sql database should I use?
what is 'mysqladmin' in mysql? : Sql dba
What are local and global variables and their differences?
How run sql*plus commands that are stored in a local file?
What is blind sql injection?
