Interested to Buy Any Domain ? << Click Here >> for more details...
difference between select column name from table name where
serviceid=2; and select max(column name) from table name
where serviceid=2;
IN ORACLE
- 3 Answers
- 8097 Views
- Intel, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different authentication modes in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is DCL?
How do I edit a procedure in sql server?
What samples and sample databases are provided by microsoft?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What does select 1 mean?
Can we insert data into view sql server?
What is the filtered index?
Differentiate between a having clause and a where clause.
What is SQL Azure Firewall?
Explain what are magic tables in sql server?
What is use of except clause? How it differs from not in clause?
