select max(salary)-1 from employeetable

To find second largest salary in Employee table

Question Posted / chitharthan

Answer Posted / chitharthan

Is This Answer Correct ?

0 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the chart in report?

165

How to create dbo table in sql server?

1007

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1189

How do I find the sql server instance name?

1014

What do you understand by integration services in sql server?

1003

How to handle error or exception in sql?

1040

How do you rebuild an identity column?

997

How to create median function?

172

What does select 1 mean?

977

What is BCNF? How is it better than 2NF & 3NF?

1066

How do I save a stored procedure in sql server?

1054

How can I get data from a database on another server?

1051

How to Update from select query in sql server?

1123

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

1035

What is a data collection table?

1051