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 are the types pl/sql code blocks?

1191

what is 'mysqladmin' in mysql? : Sql dba

1073

How delete all data from all tables in sql?

982

Which join is like an inner join?

1091

What is exit statement?

1058

What is procedure explain with program?

1063

Can we use two order by clause in query?

1015

What is an emotional trigger?

1055

How do I quit sql?

1004

What is the most important ddl statements in sql are?

1042

What is sql analyzer?

1059

What is tuple in sql?

1140

How to rename a column in the output of sql query?

1121

What is scalar and vector?

1060

What steps server process has to take to execute an update statement?

1014