Sep 23, 2015

Some Tricky SQL Queries

Hi,

select count(*) -- // 1 

select 15 -- // 15

select $   -- // 0.00 

select count('7') -- // 1 

select 'RAJ'+1 -- // Conversion Problem Error

select 'RAJ'+'1' -- // RAJ1

select (select 'RAJ') -- // RAJ

select select 'RAJ' -- // Error

select * from 'RAJ' -- // Error

select * from AccountDetials,ACTSBankDetails -- // o/p will be cross join of both tables

select count(*) + count(*) -- // 2

select 'Rajkumar Palnati HDFC' from AccountDetials -- // 'Rajkumar Palnati HDFC'

select sum(1+2*3) --// 7

select max(1+2*3) -- // 7

select max(1,2,3) -- //  Error, The max function requires 1 argument(s)

select max('RAJ') -- // RAJ

select count(select Client from AccountDetials) -- // Error syntax 


Thanks & Regards
Rajkumar Palnati

No comments:

Post a Comment