| Written Interview for SQL Server Query Dec 2020 Years
Below are some written SQL Server Query asked in interview exam. Find the output of below sql query
(1)Select 151
(2)Select $
(3)Select count('7')
(4)Select 'crackyourinterview'+1
(5)Select 'Crackyourinterview' +'1'
(6)Select (Select 'Crackyourinterview')
(7)Select Select 'Crackyourinterview'
(8)Select count(*) +Count(*)
(9)Select 'crack' from tblname
(10)select sum(1+2*3)
(11)select max(1+2*3)
(12)select max(3,4,5)
(13)select max('crackyourinterview')
(14)select 1+'1'
(15)Select '1' +1
(16)Select null+'1'
(17)Select 1 where null=null
(18)select sum(1)
(19)select sum('1')
(20)Select sum(null)
(21)select count(select id from tblname)
Answer:- Below are the answer for above questions
(1)151
(2)0.00
(3)1
(4)Error
(5)Crackyourinterview1
(6)Crackyourinterview
(7)Error
(8)2
(9)print the 'crack' same number as total number of row in table
(10)7
(11)7
(12)Error only 1 arugument
(13)crackyourinterview
(14)2
(15)2
(16)null
(17)Blank answer no return any row
(18)1
(19)Error
(20)Error
(21)Error | | |