difference between select column name from table name where
serviceid=2; and select max(column name) from table name
where serviceid=2;
IN ORACLE
Answers were Sorted based on User's Feedback
Answer / nishadks
Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int
Values:('AAA',2),('BBB',2),('CCC',2),('DDD',2)
ANS:
select column name from table name where
serviceid=2
ANS:
Column_name
----------------------
AAA
BBB
CCC
DDD
select max(column name) from table name
where serviceid=2;
ANS:
-------
DDD
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / raghu
Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int
Values:('AAA',2),('BBB',2),('CCC',2),('DDD',2)
ANS:
select column name from table name where
serviceid=2
ANS:
Column_name
----------------------
AAA
BBB
CCC
DDD
select max(column name) from table name
where serviceid=2;
ANS:
-------
AAA
Is This Answer Correct ? | 2 Yes | 2 No |
Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int
Values:('Z',2),('Y',2),('B',2),('C',2)
ANS:
select column name from table name where
serviceid=2
Will be 'C'
ANS:
select max(column name) from table name
where serviceid=2;
Will Be 'Z'
Is This Answer Correct ? | 3 Yes | 13 No |
What is the stuff?
How to define and use table alias names in ms sql server?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Write a query to get all details of employee who has maximum salary from employee table
What is user stored procedure & it purpose?
What are functions in the sql server?
What are the 3 types of schema?
How do you find the number of rows in a table?
What is row_number () and partition by in sql server?
How to populate a table in sql server?
Write a SQL command to insert and update only a particular field?