A table student_marks contain the following data ID NAME MARKS 1 A 90 2 B 65 3 C 70 4 D 81 What will be output of the following sql query? SELECT TOp 1 MARKS FROM student_marks WHERE MARKS <(SELECT MAX(MARKS) FROM student

TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE

Interviews

Post

An Article
A Blog
A News
A Video
An EBook
An Interview Question

Ask Question

.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
Java
Learn iOS Programming
OOP/OOD
SharePoint
Software Testing
Web Development
WPF

View All

A table student_marks contain the following data ID NAME MARKS 1 A 90 2 B 65 3 C 70 4 D 81 What will be output of the following sql query? SELECT TOp 1 MARKS FROM student_marks WHERE MARKS <(SELECT MAX(MARKS) FROM student_marks) a) 81 b) 70 c) 65 d) 90

By Surajit Chakraborty in SQL Server on May 27 2013

0
1.3k
2

Post Your Answer

Apr, 2014 24
it must 81(a)
- 0
May, 2013 27
a)
- 0

table student_marks contain the following data: ID NAME MARKS 1 A ...

hich is not true? a) Stored procedure can not return a value b) User defined function cannot be called from a stored pro...

Most Popular Job Functions

MOST LIKED QUESTIONS