Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 58925 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / harsha
select * from my_table1 where sal not in (select max(sal)
from my_table1) order by Sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get the query of a table in sql server?
How do I find sql server instance name?
What are the disadvantages of using the stored procedures?
Differentiate between a local and a global temporary table?
What are the differences between user defined functions and stored procedures?
Write a program using SQL queries to find a unique entry in a table.
What is data compression? : sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is the difference between resultset and resultsetmetadata?
In which format does an image save in SQL Server database ?
What is table constraint?
What are the new data types are introduced in sql 2000?
How to add more data to the testing table in ms sql server?
Which is faster statement or preparedstatement?
What are sql dirty pages?
