Interested to Buy Any Domain ? << Click Here >> for more details...
1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
- 12 Answers
- 20172 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / oracle.hemant
select max(salary) from emp where salary<(select max(salary)
from emp)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are unicode character string data types in ms sql server?
What is dbcc? Give few examples.
what are constraints? : Sql server database administration
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is public role in sql server?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How to use subqueries with the exists operators in ms sql server?
What is a DBMS, query, SQL?
In what three ways is the return statement used in a stored procedure?
What is a non-clustered index?
What is sqlcmd?
What is unpivot?
Define outer join?
Why SQL Agent is used?
What you can do to delete a table without the delete trigger firing?
