Guys generally we see that
interviewer asked very easy question but question is very tricky. Even questions
are very easy but bit difficult to give the answer. Here I am sharing a
collection of tricky sql interview question.
1. What
will be the output of Select $
Answer: 0.0
Remember that
only $ special character sql is returning the value for other special character
it will giving error.
2. What
will be the Output of
Select Count (*)
A count by
definition has to return a value, so our query implicitly has one row in it. The
result of the count is returning 1. SQL Server is effectively applying a
form to a dummy table, which has only one row. Thus you will get 1 for your
count. It is similar to DUAL table in Oracle, SYSDUMMY1 in DB2.
3. What
will be the Output of the below sql script
Select Count (‘88’)
Select Count
(88)
Both are
returning 1.
4. What
will the output of
Select (select ‘Bagesh’)
If select statement
is in () then it will be treated as derived table.
5. What
will the output of the below sql script
Select Select ‘Bagesh’
If select statement
is in () then it will be treated as derived table. If there is no () it will
throw syntax error
6. What
will be the out of the below sql script.
Select Sum (1+4*5)
Select Max(1+4*5)
Select Max(‘Bagesh’)
7. What
will the output of below sql script
Select 1 + NULL
If we add anything
on NULL the all value will be NULL. Suppose if we have null value then we need
to replace null value to some other value and then we will do any operation.
With the help of ISNULL () we replace the null value.
Above example I replace
null value to 0.
8. What
will the output of below sql script
Select Case when NULL=NULL
Then ‘Yes’ else ‘No’ end as Result
Because two null value never same.
9. What
will the output of below sql script
Select top 2 1 ‘3’
3 will the
column name and 1 is the value.
Syntax of top clause [Top 2] and the 1 is value
and [‘3’] as column name
Same sql script
we will write like
Select top 2 1 as ‘3’
10. How
to insert 100 records in a table without using loop.
Insert into Emp
(ID,Name) values (1,’Bagesh kumar singh’)
Go 100
11. For 9/2 I want the result as 4.5 write the sql
script
For getting the desirer
output first we need to convert the number to float.
12. How
we find the number of character occurs in a string for example in Bagesh Kumar
Singh how many ‘a’ character occurs.
Read More tricky sql interviews questions and answer: Click here
https://www.deskbright.com/sql/sql-interview-questions/
https://www.deskbright.com/sql/sql-interview-questions/
Excellent
ReplyDeleteThanks Vinod
DeleteHi Bru,
DeleteGreat info! I recently came across your blog and have been reading along.
I thought I would leave my first comment. I don’t know what to say except that I have
I wanted to know if we should go for SQL Always-on AG or FCI for SharePoint environment. We are planning to host the whole SharePoint environment in Azure IaaS.
what are the pros and cons of SQL Always-on AG and FCI in Azure Iaas for SharePoint.
I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.
Thanks,
Great Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Nice...
ReplyDeleteThank you..
ReplyDeleteUseful....
ReplyDeleteThanks!!!
ReplyDeleteGreat collection of question and answers thank you for sharing. Follow the link if you want OBIEE Online Training
ReplyDeleteCheck it once through MSBI Online Training Hyderabad for more info.
ReplyDelete• Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating. Power Bi Online Training
ReplyDeleteGreat Information you have shared, Check it once MSBI online course Bangalore
ReplyDeleteuseful this blog.Thanks for sharing this blog.
ReplyDeleteMSBI Training in Hyderabad
ReplyDeletehi your blog Article is very nice & thanks for sharing the information.
powerbitraining
powerbitraining in ammerpet
powerbitraining in hyderabad
yours blog was excellent and really enjoyed.Thanks for sharing and mainting blogging
ReplyDeleteData science online training in Hyderabad
Data science training in usa
Data science training in uk
I want to thank for sharing this blog, really great and informative. Share more stuff like this.
ReplyDeleteBlue Prism Training Chennai
Blue Prism Training Institute in Chennai
UiPath Training in Chennai
Data Science Training in Chennai
RPA course in Chennai
RPA Training Institute in Chennai
Blue Prism Training in Anna Nagar
Blue Prism Training in T Nagar
ReplyDeleteNice blog..! I really loved reading through this article... Thanks for sharing such an amazing post with us and keep blogging...
data science online training
best data science online training
data science online training in Hyderabad
data science online training in india
ReplyDeleteNice blog..! I really loved reading through this article...
msbi training in Hyderabad
msbi training in Pune
msbi training in Bangolore
msbi training in Hyderabad
I really enjoyed your blog Thanks for sharing and it was very usefully to me
ReplyDeleteReactJs Online Training
ReactJs Training in Hyderabad
ReactJs Training in Ameerpet
Best ReactJs Training in Hyderabad
It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful .MSBI Training Institutes in Bangalore
ReplyDeleteThanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
ReplyDeletebest servicenow online training
Thanks for sharing these nice piece of coding to our knowledge. Here, I had a solution for my inconclusive problems & it’s really helps me a lot keep updates…
ReplyDeleteOracle Training | Online Course | Certification in chennai | Oracle Training | Online Course | Certification in bangalore | Oracle Training | Online Course | Certification in hyderabad | Oracle Training | Online Course | Certification in pune | Oracle Training | Online Course | Certification in coimbatore
ReplyDeleteThrough this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
Msbi online training Hyderabad
Msbi online training India
Msbi online course
Msbi course
Msbi training
Msbi certification training
Amazing & Great informative blog,it gives very useful practical information to developer like me. oracle training in chennai
ReplyDeleteAmazing & Great informative blog,it gives very useful practical information to developer like me. oracle training in chennai
ReplyDeleteVery nice informative blog. Actually it's great article. Thanks for sharing unique content. oracle training in chennai
ReplyDeletevery special. easy to understand…. taking things from root .. stay blessed
ReplyDeleteWe have an excellent IT courses training institute in Hyderabad. We are offering a number of courses that are very trendy in the IT industry. For further information.
msbi course
msbi developer course
MSBI Certification Training
very special. easy to understand…. taking things from root .. stay blessed
ReplyDeleteWe have an excellent IT courses training institute in Hyderabad. We are offering a number of courses that are very trendy in the IT industry. For further information.
msbi course
msbi developer course
MSBI Certification Training
very special. easy to understand…. taking things from root .. stay blessed
ReplyDeleteWe have an excellent IT courses training institute in Hyderabad. We are offering a number of courses that are very trendy in the IT industry. For further information.
msbi course
msbi developer course
MSBI Certification Training
Thank you For your Valuable Info.
ReplyDeleteMSBI Training
wonderful article contains lot of valuable information. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteThis article resolved my all queries.good luck an best wishes to the team members.learn digital marketing use these following link
Digital Marketing Course in Chennai
Learn Oracle DBA for making your career towards a sky-high with Infycle Technologies. Infycle Technologies provides the top Oracle DBA Training in Chennai and offering programs in Oracle such as Oracle PL/SQL, Oracle Programming, etc., in the 200% hands-on practical training with professional specialists in the field. In addition to that, the interviews will be arranged for the candidates to set their careers without any struggle. Of all that, Cen percent placement assurance will be given here. To have the best job for your life, call 7502633633 to Infycle Technologies and grab a free demo to know more.
ReplyDeleteInfycle Technologies
#85, Medavakkam Main Rd, Rajendra Nagar, Keelkattalai, Chennai, Tamil Nadu 600091.
No.1 Oracle DBA Training in Chennai | Infycle Technologies
Sharing the same interest, Infycle feels so happy to share our detailed information about all these courses with you all! Do check them out
ReplyDeleteBest Data training in chennai & get to know everything you want to about software trainings.
I am happy & satisfied to read this blog, because I have currently enrolled into SQL Certification. Thank you for you whole information.
ReplyDeletecoin haber - bitcoin haberleri - instagram video indir - instagram takipçi satın al - instagram takipçi satın al - tiktok takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - binance güvenilir mi - binance güvenilir mi - binance güvenilir mi - binance güvenilir mi - instagram beğeni satın al - instagram beğeni satın al - google haritalara yer ekleme - btcturk güvenilir mi - binance hesap açma - kuşadası kiralık villa - tiktok izlenme satın al - instagram takipçi satın al - sms onay - paribu sahibi kim - binance sahibi kim - btcturk sahibi kim - paribu ne zaman kuruldu - binance ne zaman kuruldu - btcturk ne zaman kuruldu - youtube izlenme satın al - torrent oyun - google haritalara yer ekleme - altyapısız internet - bedava internet - no deposit bonus forex - erkek spor ayakkabı - tiktok jeton hilesi - tiktok beğeni satın al - microsoft word indir - misli indir
ReplyDeletemarsbahis
ReplyDeletebetboo
sultanbet
marsbahis
betboo
sultanbet
Reach to the best <a href="https://infycletechnologies.com/python-training-in-chennai'>Python Training institute in Chennai</a> for skyrocketing your career, Infycle Technologies. It is the best Software Training & Placement institute in and around Chennai, that also gives the best placement training for personality tests, interview preparation, and mock interviews for leveling up the candidate's grades to a professional level.
ReplyDeleteucuz takipçi
ReplyDeleteucuz takipçi
tiktok izlenme satın al
binance güvenilir mi
okex güvenilir mi
paribu güvenilir mi
bitexen güvenilir mi
coinbase güvenilir mi
instagram takipçi satın al
instagram takipçi satın alz
Infycle Technologies, the top software training institute and placement center in Chennai offers the Best Digital Marketing Course in Chennai | Infycle Technologies for freshers, students, and tech professionals at the best offers. In addition to Digital Marketing, other in-demand courses such as DevOps, Data Science, Python, Selenium, Big Data, Java, Power BI, Oracle will also be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.
ReplyDeleteInfycle Technologies offers couples for care and technology in addition to Python Training in Chennai, 100% of the internship class will be prepared. After completing the training, the participants will be sent to the upper MNCs interviews. Call 750633333 to get more information and get a free display.
ReplyDeleteseo fiyatları
ReplyDeletesaç ekimi
dedektör
instagram takipçi satın al
ankara evden eve nakliyat
fantezi iç giyim
sosyal medya yönetimi
mobil ödeme bozdurma
kripto para nasıl alınır
hello sir, I'm looking for sql and ssis training. Do you provide training?
ReplyDeleteinstagram beğeni satın al
ReplyDeleteyurtdışı kargo
seo fiyatları
saç ekimi
dedektör
fantazi iç giyim
sosyal medya yönetimi
farmasi üyelik
mobil ödeme bozdurma
Thanks to this type of article.مجازات رابطه نامشروع
ReplyDeletebitcoin nasıl alınır
ReplyDeletetiktok jeton hilesi
youtube abone satın al
gate io güvenilir mi
referans kimliÄŸi nedir
tiktok takipçi satın al
bitcoin nasıl alınır
mobil ödeme bozdurma
mobil ödeme bozdurma
MMORPG OYUNLAR
ReplyDeleteinstagram takipçi satın al
TÄ°KTOK JETON HÄ°LESÄ°
tiktok jeton hilesi
Antalya saç ekim
Takipçi satın al
instagram takipçi satın al
Metin Pvp
instagram takipci satın al
perde modelleri
ReplyDeleteSms onay
VODAFONE MOBİL ÖDEME BOZDURMA
nft nasıl alınır
ankara evden eve nakliyat
Trafik sigortasi
dedektör
web sitesi kurma
aşk kitapları
Nice post thank you.
ReplyDeletecanli slot siteleri
kibris bahis siteleri
rulet siteleri
deneme bonusu
canli poker siteleri
canli tombala siteleri
nice............!
ReplyDeletemsbi course training
spring boot certification course training
Good content. You write beautiful things.
ReplyDeletehacklink
sportsbet
mrbahis
hacklink
vbet
mrbahis
taksi
sportsbet
korsan taksi
Good text Write good content success. Thank you
ReplyDeletemobil ödeme bahis
slot siteleri
tipobet
kibris bahis siteleri
poker siteleri
betpark
bonus veren siteler
kralbet
Good article text write content successfull... thanks.
ReplyDeletebonus veren siteler
poker siteleri
tipobet
mobil ödeme bahis
kralbet
betmatik
betpark
slot siteleri
Hi, I have read a lot from this blog thank you for sharing this information. We provide all the essential topics in Data Science Course In Chennai like, Full stack Developer, Python, AI and Machine Learning, Tableau, etc. for more information just log in to our website :
ReplyDeletehttps://skillslash.com/data-science-course-in-chennai
https://skillslash.com/web-development-course-in-chennai
https://skillslash.com/web-development-course-in-pune
https://skillslash.com/web-development-course-in-bangalore
https://skillslash.com/web-development-course-in-hyderabad
Thanks for giving this sort of nice information to all of us and please keep us updated in future also.I want to share some information about the Data Structures For best career in Data Structure And Algorithms Join skillslash it is best online platform For learning Data structures And algorithms Courses for more information go through website links down :
ReplyDeletehttps://skillslash.com/best-data-structures-algorithms-course
https://skillslash.com/system-design-course
https://skillslash.com/best-dsa-course
~Th`at` w`as g`r`e`at` p`o`st`.
ReplyDelete`SQLtraining in Pune