select *from emp order by sal desc limit 1,1

how to find the second highest salary from emp table?

Question Posted / ruma

Answer Posted / ruma

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What types of commands can be executed in sql*plus?

1109

Why do we use function in pl sql?

1065

What is nosql db?

972

What is raw datatype in sql?

1048

What is the use of double ampersand (&&) in sql queries? Give an example

1139

What is the size of partition table?

1048

What is an ndf file?

994

How can we link a sql database to an existing android app?

1032

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

what is meant by nl2br()? : Sql dba

1046

What are the disadvantages of file system?

1268

What is cursor and its types?

1076

How to Declare Fixed Length String Value In PL SQL

1158

How much does sql cost?

1010

What is meaning of <> in sql?

1071