From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / apsar
select * from (select e.* from emp order by e.sal desc)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql lookup?
What is clause?
What is the use of pl/sql table?
what is “go” in t-sql? : Transact sql
What are different joins used in sql?
how to get a list of columns in an existing table? : Sql dba
How is a process of pl/sql compiled?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is normalization? How many normalization forms are there?
Is left join inner or outer by default?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Is truncate ddl or dml?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is acid property in a database?