Hi guys, Today i have a simple question for you & my question is what would be the result of the query-
USE tempdb GO CREATE TABLE #Employee (EmpId INT, NAME VARCHAR(15), Salary INT, Expenses VARCHAR(5)) INSERT INTO #Employee SELECT 1056, 'Viraj', 230000, 5216 UNION SELECT 2095, 'Dheeraj', 98000, 7892 UNION SELECT 7258, 'Raman', 42000, 923 UNION SELECT 6323, 'jay', 12000, 8999 SELECT * FROM #Employee SELECT max(Salary) 'Salarymax', max(Expenses) 'Expensesmax', max(Cast(Salary AS VARCHAR(6))) 'Salary_max', max(Cast(Expenses AS INT)) 'Expenses_max' FROM #Employee --<--Answer for this query DROP TABLE #Employee
Isn’t it a simple question-
If you say, it should be 230000,8999,230000,8999. then it is wrong. You should check your basics.
The answer is 230000,923,98000,8999
Do you know the datatype of salary is int & for expenses it is varchar. In comparison, integers are compared with complete number while string are compared with one by one character.