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

How do you write a subquery?

1029

How show all rows in sql?

1014

Does sql profiler affect performance?

995

What is character functions?

1061

What does 0 mean in sql?

966

What is right join in sql?

1091

What are variables in pl sql?

1167

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

953

What is trigger and stored procedure in sql?

1036

What is materialized view in sql?

921

What are the sql aggregate functions?

1133

What are different clauses used in sql?

1115

What is the plv (pl/vision) package offers?

1053

What is crud stand for?

998

What does count (*) mean in sql?

1589