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 is a null value?

1191

what is foreign key? : Sql dba

1110

What is an invalid partition table?

1068

What are the different types of sql commands?

1180

how many groups of data types? : Sql dba

1078

Is null operator in sql?

1094

Can I learn sql in a week?

1122

What does truncate mean in sql?

1086

is it possible to pass an object or table to a procedure as an argument?

1179

How do I view a sql trace file?

1064

What does trigger mean in psychology?

1009

What is the maximum number of rows in sql table?

1081

what are wild cards used in database for pattern matching ? : Sql dba

1206

Enlist the data types that can be used in pl/sql?

1112

What is a system versioned table?

1043