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
- 8374 Views
- Intel, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manish
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 |
Post New Answer View All Answers
What is the command to change the recovery model?
How to execute a sql statement using mssql_query()?
List the different types of joins?
What is difference between getdate and sysdatetime in sql server 2008?
How to drop an existing table with "drop table" statements in ms sql server?
What is an execution plan?
how we use window authentication connection with sql server.?
How to execute function in stored procedure sql server?
What is implicit cursors?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How to find the second highest salary of an employee?
Why do we use stored procedures in sql server?
What is a system database and what is a user database?
What languages bi uses to achieve the goal?
How to retrieve error messages using odbc_errormsg()?
