Given an employee table, how would you find out the second
highest salary?
Answer Posted / vivek mohan singh
select salary from tablename order by salary desc limit 1,1;
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is dbms and its application?
Write the fastest query to find out how many rows exist in a table?
What is normalization? Explain different levels of normalization?
How to read and create .LDC data files which are used by linguatic dictionary.
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Why does this query return 0?
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 the key features of dbms?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
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?
fact table and dimension table containg one to many relationship or many to one relastionship
How can I detect whether a given connection is blocked?
How to replace not in with not exist?
Explain about network model?
Explain about xml databases?