SELECT * FROM Student_infowhere S_id=(select max(S_id)from Student_info where S_id<(select max(S_id)from Student_info))
For Answers, see/post comments
Discussion List
-
▼
2008
(95)
- ► 07/20 - 07/27 (6)
- ► 07/13 - 07/20 (10)
- ► 07/06 - 07/13 (4)
- ► 06/15 - 06/22 (8)
- ► 05/25 - 06/01 (6)
- ► 05/18 - 05/25 (13)
- ► 05/11 - 05/18 (12)
-
▼
05/04 - 05/11
(21)
- Explicit Member Implementation in C#
- To to find date difference in C#
- Binding Data to DropdownList
- Data Relation between Two Different Datasets
- How to filter the datatable
- Remove duplicate records from a table
- Serialize a Remotable Dataset
- Create a Generic Colletion to store objects in VB.Net
- How to get the available RAM and the CPU usage?
- How to find out the nth highest number in a databa...
- Delete a record from the database
- How to select second max from Database Table in SQ...
- How to call a stored procedure from C#
- Error Handling
- Object not set
- variable losing value on postback
- Using IComparable and IComparer to compare objects
- Treeview
- Get user control from existing .net application
- Enable CLR Debugging
- Convert Database data to XML
- ► 04/27 - 05/04 (15)
1 comment:
Here Table name is Detail and having one column 'age'
Query to find the second highest age is as below
select age from detail where 1=(select count(distinct(age)) from detail a where a.age > detail.age )
Post a Comment