select * from salary where rowno<6

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / mohammad murtuza ali

24 Answers
50754 Views
Cap Gemini, iNautix, I also Faced
E-Mail Answers

Answer Posted / mohammad murtuza ali

select * from salary where rowno<6

Is This Answer Correct ?

4 Yes

15 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is int identity in sql?

1064

Does truncate free space?

948

Does view store data in sql?

902

how to use in conditions? : Sql dba

962

What are the main features of cursor?

1041

What is sql profiling in oracle?

998

Are views faster than queries?

923

What is right join sql?

922

what are sequences

1622

What are the constraints available in sql?

999

Is sql between inclusive?

1064

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

993

what is self join and what is the requirement of self join? : Sql dba

1078

What is loop in pl sql?

984

Can we use join in subquery?

1022