how to find the second highest salary from emp table?
Answer Posted / shiva
select salary from table_name where salary <(select salary
from table_name);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many groups of data types? : Sql dba
Define commit?
what are date and time functions in mysql? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Does sql use python?
Which operator is used in query for pattern matching?
what is difference between delete and truncate commands? : Sql dba
What is data control language?
what is cursor. write example of it. What are the attributes of cursor.
how to run 'mysql' commands from a batch file? : Sql dba
What is the maximum size of sqlite database?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Explain polymorphism in pl/sql.
Explain scalar functions in sql?