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
Why does this query return 0?
What is the physical representation for a many-to-many relationship?
Explain about query and reporting.
What is dbms and its application?
Can an extended stored procedure be called from inside a user-defined function?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
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?
Explain the role of indexing in databases?
fact table and dimension table containg one to many relationship or many to one relastionship
How can you log an error to the server event log from a stored procedure?
Explain what a database is?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Who are end users in dbms?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What is the maximum length of an extended property?