adspace


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

What is your daily office routine?

2353


how to start mysql server? : Sql dba

1279


Does group by remove duplicates?

1122


how many tables will create when we create table, what are they? : Sql dba

1157


Is inner join faster than left join?

1289


what is sql server agent? : Sql dba

1191


what are the advantages of sql ? : Sql dba

1154


define sql insert statement ? : Sql dba

1110


what is collation? : Sql dba

1242


Is primary key always clustered index?

1101


what is schema? : Sql dba

1165


Is primary key clustered index?

1028


how to use regular expression in pattern match conditions? : Sql dba

1125


what is dbms? : Sql dba

1072


What is the current version of postgresql?

1189