Given an employee table, how would you find out the second
highest salary?
Answer Posted / sowjanya
Select * from emp where sal=(select Max(sal) from emp where
sal<(select Max(Sal) from emp)
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
What are data modelling techniques?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Explain about xml databases?
What is an application role and explain a scenario when you would use one?
How to use online Backups?
Explain about relational database management systems?
What are the three types of database design?
Can an extended stored procedure be called from inside a user-defined function?
Explain about the hierarchical model of the database?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Who are end users in dbms?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Which data type cannot be used as a parameter in a udf?
Explain about a primary key?