find 2nd highest salary of person using cursor concept?
Answer Posted / krish
select max(sal) frem tbl where sal <(select max(sal) from tbl;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between createstatement and preparedstatement?
What are orphan records?
How many types of database relationship in sql server?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Tell me what is normalization? Explain different forms of normalization?
What are the events recorded in a transaction log?
What are the advantages of passing name-value pairs as parameters?
What is built-in function?
How to declare a cursor with "declare ... Cursor" in ms sql server?
How to create an index on an existing table in ms sql server?
Explain multiserver query
How to test odbc dsn connection settings?
Where to find ntwdblib.dll version 2000.80.194.0?
what are different types of backups available in sql server? : Sql server database administration
Do you know exporting and importing utility?