To find second largest salary in Employee table
Answer Posted / chitharthan
select max(salary)-1 from employeetable
Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
how can a database be repaired? : Sql server administration
List all the types of user-defined functions?
What is 2nf in normalization?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
How can you know if the row fetched from cursor is still valid in underlying table?
Difference between DELETE and TRUNCATE?
What is the difference between insensitive and scroll cursor?
Why I have to use stored procedures?
How many types of schemas are there?
Differentiate between truncate vs delete in mssql?
What are logical/boolean operations in ms sql server?
What is dynamic cursor in SQL SERVER?
How to use go command in "sqlcmd"?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?