Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20449 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / mohammad murtuza ali
select salary from employeetable where empsal is < max(salary)
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Explain the Ways to improve the performance of a sql azure database?
What are scheduled tasks in sql server?
What are the different types of normalization?
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? : Sql server administration
How to create a new login name in ms sql server?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is a Join and explain its types?
What are sql dirty pages?
Does sql server 2000 full-text search support clustering?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Is the order of columns in the set clause important in ms sql server?
Explain cross join or cartesian product in sql?
Explain full-text query in sql server?
What is a linked server in sql server?
