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

find out first highest salary?

Question Posted / o p yadav

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

Please Help Members By Posting Answers For Below Questions

How translate command is different from replace?

1034

what is IDE,DMV in sql server?

2773

Are truncate and delete commands same? If so why?

1095

Can select statements be used on views in oracle?

1002

What is the best way to do multi-row insert in oracle?

1032

What is the implicit cursor in oracle?

1054

what is reindexing?

1625

Explain what are the different type of segments?

921

How do you store pictures in a database?

965

What is the difference between alert log file and tarce file ?

2118

How many categories of data types?

954

What are the different windows events activated at runtime ?

2853

How to create a table index?

1088

What happens if the imported table already exists?

989

How do I know if oracle is installed on windows?

894