one table has four field id,name,design,salary. i have to
find maximum salary .
Answer Posted / sujit
select max(sal) from <tablename>
if this answer not correct plz give me commets on the answer
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Can a table have 2 foreign keys?
Explain time data type in sal server 2008?
Does transparent data encryption provide encryption when transmitting data across the network?
what is database replication? : Sql server database administration
What is index fragmentation in ms sql server?
What is the difference between a fill factor of 100 and 0?
Tell me about normalization in DBMS.
What is single-user mode?
How do I find the default sql server instance?
What command do we use to rename a db, a table and a column?
Explain comment on transactions?
How do you identify a foreign key?
How to drop an existing table with "drop table" statements in ms sql server?
How to Insert multiple rows with a single insert statement?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration