select ( salary) as sal from employee ORDER by salary DESC limi

find out the third highest salary?

Question Posted / sudesh indore

Answer Posted / sudesh indore

select ( salary) as sal from employee ORDER by
salary DESC limit 2,1

------------
i hope that will help u thanx

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2184

What do you mean by redo log file mirroring?

978

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2219

Can we connect to ORACLE db using Windows Authentication?

1183

What are the built-in functions used for sending Parameters to forms ?

3309

Can you have more than one content canvas view attached with a window ?

2264

What is archive log in Oracle?

1071

How to create a table in a specific tablespace?

916

What is a subquery in oracle?

1043

What is memory advisor in Oracle?

1027

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2248

What are dml statements in oracle?

1045

What is oracle rownum?

889

Is the After report trigger fired if the report execution fails ?

2879