From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / anil
select * from test.emp where salary=(select max(salary) from test.emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the insert into statements in sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
How many parts of a pl sql block are optional?
What is PL/SQL Records?
Is id a reserved word in sql?
how to get help information from the server? : Sql dba
How do I write a cron which will run a sql query and mail the results to agroup?
Explain what is a column in a table?
Explain the uses of a database trigger?
Can a foreign key have a different name?
What is over () in sql?
Why do we go for stored procedures?
Is it possible to update views?
What does seeding a database mean?