1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

To find second largest salary in Employee table

Question Posted / ela tiku

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


Please Help Members By Posting Answers For Below Questions

What is instead of trigger sql server?

502

What is temporary table in sql server? Why we use temp table?

520

How to list all columns in a table using odbc_columns()?

536

What do you mean by 'normalization'?

608

What is difference between sql and sql server?

546




What is global temp table?

564

What does indexation mean?

533

Define Unique Key?

596

what is the different types of backups available in sql server? : Sql server database administration

504

Write an sql query for deleting duplicate rows?

553

What are truncate options available in sql server? : sql server database administration

585

How to modify existing triggers using "alter trigger"?

531

What are sql dirty pages?

561

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1969

Why we need sql server?

561