Answer Posted / cpnagar
select top 1 salary from(select distinct top 3 salary from
emp order by salary desc)as e order by e.salary
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Explain full-text indexing?
If no size is defined while creating the database, what size will the database have?
What are the properties of primary key?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the different authentication modes in sql server? How can it be changed?
What is meant by datasource?
What are different types of table joins?
How do I save a stored procedure in sql server?
How to populate a table in sql server?
Explain the types of indexes.
Can group by be used without aggregate functions?
How much memory that we are using in Logshipping Concept?
What factors you will consider calculating the storage requirement for that view?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration