Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20864 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / ela tiku
Select Max(SAL) FROM emp WHERE sal<(SELECT MAX(SAL) FROM
emp)
<<<assuming sal is the column name and emp is the table
name>>>
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to list all dsn entries on your local machine using odbc_data_source()?
How to modify existing triggers using "alter trigger"?
Name three of the features managed by the surface area configuration tool? : sql server security
How to use union to merge outputs from two queries together in ms sql server?
explain declarative management framework (dmf) in sql server 2008?
How would we use distinct statement? What is its use?
Explain few of the new features of sql server 2008 management studio
Where are full-text indexes stored?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the difference between clustered index and primary key?
How can a database be repaired?
How to list all field names in the result set using mssql_field_name()?
which backup strategy you are following at ur company
How do you rename a table in sql server?
What is meant by indexing files?
