find out first highest salary?

Answer Posted / o p yadav

select max (salary) from emp
emp is a table name and salary is a coloum name

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a data lock in oracle?

619


What is oracle instant client?

581


What is a proxy class?

570


Why does for update in oracle 8 cause an ora-01002 error?

559


What privilege is needed for a user to insert rows to tables in another schema?

574






What is an oracle data file?

623


What is a cursor variable?

588


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1003


What is key preserved table?

574


What are dml statements in oracle?

627


How to drop an existing table in oracle?

604


Name the various constraints used in oracle?

574


State and explain about oracle instance?

560


What are the set operators union, union all, minus & intersect meant to do?

572


How many types of cluster table in Oracle?

585