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

Answer Posted / mohammad murtuza ali

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

Is This Answer Correct ?    2 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view a view in sql?

503


Explain ttitle and btitle.

668


What are stored procedures in mysql?

555


What is the use of function in sql?

533


What is difference between procedure and trigger?

512






Why cannot I use bind variables in ddl/scl statements in dynamic sql?

662


What is difference between stored procedure and trigger?

529


how to use like conditions? : Sql dba

571


Is sql pronounced sequel or sql?

733


What is oracle pl sql developer?

529


What is full join in sql?

518


Can procedure in package be overloaded?

604


Why do we use sql constraints? Which constraints we can use while creating database in sql?

543


what are dynamic queries in t-sql? : Transact sql

555


What is the usage of distinct keyword?

627