select * from SALARY where where rowno<6 and empname like empname

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

Question Posted / mohammad murtuza ali

Answer Posted / mohammad murtuza ali

select * from SALARY where where rowno<6 and empname like
empname

Is This Answer Correct ?

2 Yes

29 No

Please Help Members By Posting Answers For Below Questions

What is audit logout in sql profiler?

992

Which is better cte or subquery?

990

Which query operators in sql is used for pattern matching?

920

what is data manipulation language? : Sql dba

964

what are integrity rules?

988

What is the difference between delete and truncate commands?

992

Explain character-manipulation functions?

1086

Why use stored procedures?

1042

What are sql functions? Describe the different types of sql functions?

1081

Explain the uses of control file.

1009

Can you have more than one trigger on a table?

963

How do I start sql from command line?

980

How can a pl sql block be executed?

911

Why do we use cursors?

942

Can a trigger call a stored procedure?

1025