write sql program to get the detail of student in a class?
Answers were Sorted based on User's Feedback
Answer / bhagwat sharma
create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5
insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5
select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / muruga nandhini.p
create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5
insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5
select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5
| Is This Answer Correct ? | 4 Yes | 3 No |
What is the sql profiler?
What is fill factor and pad index?
Define self join in sql server joins?
How to find 6th highest salary from Employee table ?
What is "scheduled jobs" or "scheduled tasks"?
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
How do I find my localdb version?
How to transfer Logins from SQL Server 2000 to 2005
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to stop log file growing too big?
Explain fundamentals of Data ware housing & OLAP?
What are basics of policy management?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)