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
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What is normalization? Explain different levels of normalization?
Who are end users in dbms?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain what a database is?
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.
How to use online Backups?
Explain the process of the user request and data generating?
Explain about the storage and physical database design?
How can you log an error to the server event log from a stored procedure?
What is a database development?
How to customize error conditions.
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain the role of indexing in databases?
What is the maximum length of an extended property?